Posted to microsoft.public.excel.worksheet.functions

Raj

external usenet poster

Posts: 130

conditional formatting of date

i have a column 'target date' in my excel sheet. this column contains my
target date for my jobs. i want to display the dates in red color for those
entries that are older than today.

i.e. if today is 12/28/2006
target date
12/29/2006
12/26/2006 -- this cell in red

how to do it automatically? Thanks in advance

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
Deferring conditional formatting?	Pheasant Plucker®	Excel Discussion (Misc queries)	14	March 17th 06 08:17 PM
Conditional Formatting Date	Humpy	New Users to Excel	4	February 25th 06 10:44 AM
Conditional Formatting	Dee	Excel Worksheet Functions	5	November 3rd 05 10:04 AM
Conditional formatting of date	cebubum	Excel Discussion (Misc queries)	4	June 28th 05 03:27 AM
Conditional Formatting (Date vs Number)	[email protected]	Excel Discussion (Misc queries)	7	December 20th 04 10:23 PM

All times are GMT +1. The time now is 05:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us