Thanks - I'm still learning......do I do a 2nd cond format to turn the cell
(C2) back to white after data has been entered into it - right now it stays
red even though the data has been selected?
--
DWillcox


"David Biddulph" wrote:

You turn the colour off by having anything other than "Special" in C1.
If you wish to include a further condition in your formatting criterion, you
can combine conditions using AND or OR.
--
David Biddulph

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