Did you try either of the answers to your identical question yesterday?
--
David Biddulph

"Willco3" wrote in message
...
nI have a drop down menu in C1 with approx. 20 options to choose from. I
want C2 to turn red if a particular option is picked from the box (this
applies to 1 out of the 20 only) - how do I do this?. Any help is
appreciated. Thanks.
--
DWillcox