Posted to microsoft.public.excel.worksheet.functions

Compass Rose Compass Rose is offline

external usenet poster

Posts: 30

Conditional formatting for range of cells?

Cells B2 to B150 contain dates. Is it possible to apply conditional
formatting to B1 so that it turns red if any of the dates in B2:B150 are
greater than TODAY()? If so, what is the formula?

TIA
David

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 similar to shading alternating rows	Conan Kelly	Excel Worksheet Functions	10	August 22nd 06 11:13 PM
counting cells based on conditional formatting	Marc	Excel Discussion (Misc queries)	3	July 5th 06 08:37 PM
conditional formatting 2 cells	debjocc	Excel Worksheet Functions	6	June 2nd 06 03:21 PM
Conditional Formatting based on other cells	userzero	Excel Worksheet Functions	4	April 6th 06 11:16 PM
Copying cells with conditional formatting	Benfanfromlo	Excel Discussion (Misc queries)	3	February 10th 05 06:12 PM

All times are GMT +1. The time now is 10:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us