Steven Stadelhofer

Posts: n/a

Conditional formating w/ Date

I would like to format a date cell based on todays date.
e.g., if date before today format red font, if date after
today format black font. I can't seem to get this
condition to work for all my cells? not sure why.
Thanks for your help.

Steve

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formating	csfrolich	Excel Discussion (Misc queries)	2	January 17th 05 02:07 PM
Conditional Formating	Aviator	Excel Discussion (Misc queries)	1	January 12th 05 05:37 PM
Conditional Formatting (Date vs Number)	[email protected]	Excel Discussion (Misc queries)	7	December 20th 04 10:23 PM
Conditional Formating when result is text	Lary	Excel Worksheet Functions	1	December 16th 04 02:13 AM
30 Day Aging Report Using Conditional Formating	Tiegris	Excel Worksheet Functions	0	November 4th 04 10:07 PM

All times are GMT +1. The time now is 04:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us