Posted to microsoft.public.excel.misc

external usenet poster

Posts: 144

conditional formating

I have the following formula for column D and E
=D2<Today() red
=(D2-Today())<30 green
I need to add a formula that if a date is in column c then column D and E
are black.

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	Afia	Excel Discussion (Misc queries)	1	February 23rd 10 03:49 PM
Conditional Formating	[email protected]	Excel Discussion (Misc queries)	5	May 14th 08 10:53 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
conditional formating	Jed	Excel Discussion (Misc queries)	3	June 14th 05 05:11 PM
Conditional Formating	Itch	Excel Discussion (Misc queries)	1	March 8th 05 06:13 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us