Unable to set conditional formating with formula columns that create date values. When using Date based columns there are number of date specific conditional tests. Whereas, with formula columns there are no date specific tests even when the resultant value is a date. It would be great if the formula column conditional formating was value type aware i.e. date etc. Alternatively, to have an additional formula function that enables you to set resultant values specific to one other column that could be a date column.
Date based column date specific conditional colouring.
Current formula column specific conditional colouring.
Alternatively, have a link to mechanism between Date and Formula based columns i.e the Formula column linked to a Date column that can be conditionally formatted.