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