#1
|
|||
|
|||
Condition formating for date?
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 |
#2
|
||||
|
||||
If your date and time is in A1 perhaps something like
Code:
=int(A1)<>today()
__________________
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 |
#3
|
|||
|
|||
Thanks, worked great
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro - replace with condition | ubns | Word VBA | 1 | 05-02-2012 12:52 AM |
Date formating problem in EXCEL 2003 | lyngio | Excel | 10 | 01-27-2012 03:37 AM |
check with condition | karti | Word | 2 | 03-15-2011 06:06 AM |
Formula in a Cell with condition? | Learner7 | Excel | 1 | 07-19-2010 10:10 AM |
Retrict Method Condition | markp | Outlook | 0 | 12-22-2005 05:38 PM |