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

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

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

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

Select cell B1
Goto the menu FormatConditional 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

"Kelly Lim" wrote in message
...
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

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

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

"T. Valko" wrote:

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

Select cell B1
Goto the menu FormatConditional 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

"Kelly Lim" wrote in message
...
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