Posted to microsoft.public.excel.misc

onequestion onequestion is offline

external usenet poster

Posts: 2

Excel 2000 - Highlighting a date.

Hi,

I have a date in a cell. If this date is within the next 3 months then I
need the cell to be shaded red. And then when the date expires it needs to be
shaded red also...

How can I achieve this? I have Excel 2000 by the way.

Many 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 formatting and Highlighting Date Range	[email protected]	Excel Discussion (Misc queries)	0	July 18th 07 04:15 PM
Conditional formatting and Highlighting Date Range	[email protected]	Excel Discussion (Misc queries)	0	July 18th 07 04:14 PM
Date highlighting	Michael Curry	Excel Discussion (Misc queries)	2	November 7th 06 08:31 PM
Excel 2000 Date Question	Steven	Excel Worksheet Functions	7	March 21st 06 07:49 PM
Date analysis key in Excel 2000	NSXR	New Users to Excel	1	August 31st 05 11:24 AM

All times are GMT +1. The time now is 04:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us