Conditional Formatting Dates

[jonathan.haynes]

Hi,

I am looking to put some conditional formatting on dates however need some IF statements somewhere.

Further explained in the example spreadsheet.

Example3.xlsx

Cheers

[:) Sixthsense :)]

Please confirm which column cell needs to be highlighted?

[Pepe Le Mokko]

Like this ?

[etaf]

use the following three conditions
red
=AND(P4="",TODAY()+21>J4)
amber
=AND(P4="",TODAY()+42>J4)
green
=AND(P4="",TODAY()+42<J4)


in that order and use stop if true

see attached

[jonathan.haynes]

This is great. Thanks both