nicko68

Posts: n/a

how to create conditional format linked to date

I wish to create a conditional format linked to date, for example if info. in
cell is less than 2 months old, the cell is green, if info. is more than 2
months old the cell turns red.

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
Create conditional IF to format cells using 6 different colours	NZJen	Excel Worksheet Functions	2	August 17th 05 03:41 PM
DATE Format	Venkat	Excel Worksheet Functions	1	August 16th 05 12:23 AM
date format in excel not in line with control panel regional setti	GrahamR	Excel Discussion (Misc queries)	3	August 2nd 05 06:48 PM
Date Format - Conversion	tinkertoy	Excel Discussion (Misc queries)	1	July 14th 05 06:24 PM
format the "date" button for a header	sc11	Excel Discussion (Misc queries)	1	May 12th 05 03:48 AM

All times are GMT +1. The time now is 01:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us