Formula for Drop down list and the cell next to it changes colours

[Guest]

Dear Sir / Madam,

I need help on a formula or anything which i have this cell when i click on
the drop down list of containing "pending" & "closed".

I select "pending" from the drop down list and the cell next to it,
background turns to "red" colour.

When i select "closed" from the drop down list and the cell next to it,
background turns to "yellow" colour.

Please advise how could i do this?

Thank You!
Warmest Regards,
Kelly

 

[T. Valko]

Assume the drop down list is in cell A1 and you want to format cell B1:

Select cell B1
Goto the menu Format>Conditional Formatting
Condition 1
Select: Formula Is
Enter this formula in the little box:
=A1="Pending"
Click the Format button
Click the Pattern tab and select a red fill color
Click OK
Click Add
Condition 2
Select: Formula Is
Enter this formula in the little box:
=A1="Closed"
Click the Format button
Click the Pattern tab and select a yellow fill color
OK out

Biff

 

[Skeetra27]

Is there an easier way to make this work for each cell in the drop down menu?
I have 11 options for the drop down? Do I have to make a rule for each? (I
also have several other drop down menus throughout the workbook on different
sheets that would need to be the same)

Christine