thanks Max that worked - one other thing, how do I turn off the color in C2
once an option has been selected?
--
DWillcox


"Max" wrote:

Assuming the particular option results in C1 having the value: Special

Select C2, then apply conditional formatting
using Formula is:
=C1="Special"
Format to taste, Ok out.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Willco3" wrote:
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