Conditional Formatting Issue with a FORMULA

MikeExcel

New member
Joined
Jun 20, 2019
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2003
I put this code into Conditional Formatting


Date(2019,6,19) < TODAY()
and if true change font colour....it is true and the contents of the cell should change colour



I put this same code into a cell and it came back TRUE


Why doesn't it work???

I tried rewriting the code as follows:
TODAY() > DATE(2019,6,19) and it worked and then it didn't and does not work now

PLEASE HELP!!! SO frustrating



Excel 2003


Thanks
 
Back
Top