Posted to microsoft.public.excel.misc

paula k

external usenet poster

Posts: 9

multiple cells conditional formatting

I want to highlight a cell through conditional formatting - it depends on the
results of multiple cells. So, how could I put a formula in for conditional
formatting for the following:

inside the conditional cell there is a date 1/29/07

A3 B3 C3 D3
1/1/07 1/15/07 1/29/07 2/1/07

I want the conditional cell to highlight if any of the a3:d3 cells = 1/29/07

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
Copying Conditional Formatting to multiple cells	[email protected]	Excel Discussion (Misc queries)	2	April 10th 07 10:54 AM
Excel Conditional Formatting color multiple cells for 1 logical	LDUNN1	Excel Worksheet Functions	2	October 23rd 06 02:12 PM
multiple conditional formatting	Robin Krupp	Excel Worksheet Functions	0	September 11th 06 04:13 PM
conditional formatting to multiple cells	TC	Excel Worksheet Functions	6	January 7th 06 11:41 PM
Conditional Formatting Multiple cells based on 2 cells	Louis Markowski	Excel Worksheet Functions	2	June 1st 05 05:26 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us