Rory Carroll

Posts: n/a

highlighting cells which have dates later than...

I would like to highlight date cells in a different color which occur for
example after 1/1/2000.

The dates will be all on a colum, some before 1/1/2000 and some after.

In addition to just highlighting the cell itself, is there a way to
highlight adjacent cells.

Any help or pointers would be greatly appreciated.

Regards, Rory

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
Curser not highlighting cells	SCOTTS	Excel Discussion (Misc queries)	1	January 18th 05 08:42 PM
Dates in 2005 format cells are not entering correctly.	snixflowergirl	Excel Worksheet Functions	2	January 5th 05 05:13 PM
Sequential dates in different cells	slewis3	Excel Worksheet Functions	2	December 24th 04 12:33 AM
Sequential dates in different cells	NuHorizon	Excel Worksheet Functions	1	December 23rd 04 11:39 PM
conditional formating - Highlighting text cells based on sales res	ANDREW_B	Excel Discussion (Misc queries)	7	December 2nd 04 04:27 PM

All times are GMT +1. The time now is 05:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us