Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|