Conditional Formatting

W

Willco3

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.
 
M

Max

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.
 
W

Willco3

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

David Biddulph

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.
 
W

Willco3

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?
 
D

David Biddulph

With the condition Max specified, it should be red when C1="Special" and not
coloured otherwise. Is that what it's doing? Is that what you want?

If not, you'll have to explain the problem in more detail. If you need to
explain exactly what you've got, copy the formula from your CF condition and
paste it here; don't try to retype it here.
 
W

Willco3

Here's what I have - when a particular function (flex) is picked from a drop
down menu in C1 - the next cell (C2) turns red as an indicator that they need
to select another option from that (C2) drop down menu - the formula I have
is =N13="flex" - once the second selection is picked in C2 I want the red to
disappear but I dont know how to write the formula - thanks for all your help.
 
Top