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

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

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

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

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

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.
--
David Biddulph

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

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

sorry - couldn't see yesterdays ? - thought it didn't go through..........
--
DWillcox


"David Biddulph" wrote:

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