Junior Member

Posts: 21

conditional formating - Help

Hi
Can Anyone help me with this
I want excel to highlight the far most date from today in red, and next far most in yellow in a following table like this...

XXXX
01 Nov 2008
14 Nov 2008
12 Oct 2008
06 Nov 2008
31 Oct 2008

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	Renee Cole	Excel Discussion (Misc queries)	5	September 14th 08 09:30 AM
Conditional FOrmating	Maggie[_4_]	Excel Worksheet Functions	2	November 29th 07 01:59 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
Conditional Formating	Craley76	Excel Discussion (Misc queries)	3	June 29th 05 08:39 PM
conditional formating	Jed	Excel Discussion (Misc queries)	3	June 14th 05 05:11 PM

All times are GMT +1. The time now is 03:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us