Hi, I have cells include a certain date and time, in format: "2012-05-31 08:45:39", and I want to make a rule/condition format that make the text red if the date is not today.



I tried make a rule that say, if cell is less then =Today(), but its not work.

Any solution?
//yabbah

If your date and time is in A1 perhaps something like

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks, worked great