Posted to microsoft.public.excel.misc

dan

external usenet poster

Posts: 866

Conditional Formating For a Date

I would like to set a conditional format for a date, day-month-2 digit year.
If I enter any give date in a cell, and once that date exceeds 2 yrs, then I
would like the text or the cell to be highted to a color.
Thanks

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 based on Date	Flcnmech	Excel Worksheet Functions	1	February 14th 08 08:21 PM
Conditional Formating	Jithu	Excel Discussion (Misc queries)	1	September 27th 07 01:01 PM
Conditional Formating Based on Date	Roy	Excel Discussion (Misc queries)	5	June 7th 06 04:49 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
Conditional formating w/ Date	Steven Stadelhofer	Excel Worksheet Functions	1	February 3rd 05 05:29 PM

All times are GMT +1. The time now is 07:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us