Is this possible?

I would like to change the color or formating of multiple cells based on
another cells value and or the value in a drop down list.

Conditional formating does not seem to be able to do this.

Thanks!

Hi!

Can you provide more detail? (and be specific)

Biff

-----Original Message-----
Is this possible?

I would like to change the color or formating of multiple
cells based on
another cells value and or the value in a drop down list.

Conditional formating does not seem to be able to do this.

Thanks!
.

Hi
as an example:
- range of cells is B1:C20
- drop-down to check is in A1
- color B1:C20 if cell A1 contains the value 20

Try the following:
- select B1:C20
- goto the conditional format dialog
- enter the following formula:
=$A$1=20
- choose your format


--
Regards
Frank Kabel
Frankfurt, Germany


A-man wrote:
Is this possible?

I would like to change the color or formating of multiple cells based
on another cells value and or the value in a drop down list.

Conditional formating does not seem to be able to do this.

Thanks!

In the Conditional Formatting dialog box, choose 'Formula Is' from the
first dropdown list. Then, enter a formula that refers to the cells you
want to check.

There's an example he

http://www.contextures.com/xlCondFormat02.html

A-man wrote:
I would like to change the color or formating of multiple cells based on
another cells value and or the value in a drop down list.

Conditional formating does not seem to be able to do this.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html