Condition formating for date?

		Microsoft Office Forums > Microsoft Excel > Excel
Condition formating for date?

FAQ

Thread Tools

Display Modes

05-31-2012, 01:04 AM

yabbah

Windows XP Condition formating for date?

Office 2007

Novice

Join Date: Mar 2012

Posts: 8

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:41 PM.