Conditional Formatting based on Values in a List

[KNicho41]

Looked through the forum and couldn't find a solution to the the exact problem I'm seeing. I have a drop down list in excel 2010. List has 21 items. What I am looking to do is based on the value in the list (ie item #1), I would like my spreadsheet to conditionally format a group of cells. For example: If Drop Down says "BLUE," I need cells B3, B5, and B6 to have Red Outline and Black Fill.

Thanks in advance!

[Andrew-R]

You can use conditional formatting.

Select the cells you want to format and use a formula as the condition. For example, if your drop-down list was in cell A1 then the formula would be:

=$A$1="BLUE"

You can then specify whatever colours you want for the cells.

[KNicho41]

Works perfect! Thanks!