Posted to microsoft.public.excel.newusers

Roger[_3_] Roger[_3_] is offline

external usenet poster

Posts: 14

conditional formatting - dates

Hi
I'm using Excel 2007 and would like to know how to conditionally
format dates so the color changes as per:
Green - the last 3 days
Orange - 4 to 7 days old
Red - older than 7 days

Is there a single formula that can do this under the conditional
formatting or do I need to do 3 rules?

Cheers

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 Formatting with Dates	JoAnn	New Users to Excel	2	February 25th 08 03:12 PM
Conditional Formatting Dates	Chas2	Excel Discussion (Misc queries)	5	February 2nd 08 09:26 PM
Dates in Conditional Formatting help!!!	Corey	Excel Worksheet Functions	1	July 27th 06 10:08 AM
Conditional Formatting with Dates	WLMPilot	Excel Worksheet Functions	2	May 3rd 05 05:22 PM
Conditional Formatting Dates	John	Excel Worksheet Functions	11	December 29th 04 08:43 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us