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 |