Posted to microsoft.public.excel.programming

John Web[_2_] John Web[_2_] is offline

external usenet poster

Posts: 3

Cell colour format according to date

If a cell value is equal to today I want the colour to change to red. I have
entered =TODAY as a conditional formatting value but the cell colour does not
change. The cell has been formatted as ddd dd mmm. Any ideas please.

Thanks in advance for any help
John

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
Can I Sum by Cell Colour or Format?	Ashley	Excel Discussion (Misc queries)	1	February 17th 10 07:05 PM
Format Cell Colour	scottymelloty	Excel Worksheet Functions	0	November 18th 04 04:13 PM
Format Cell Colour	scottymelloty	Excel Worksheet Functions	0	November 18th 04 04:08 PM
Format Cell Colour	scottymelloty	Excel Worksheet Functions	2	November 17th 04 08:19 PM
Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown	Steve[_52_]	Excel Programming	5	June 15th 04 11:45 AM

All times are GMT +1. The time now is 10:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us