help with format / formula

[SS]

in C2, 2 choices (menu) Single or Multiple

single refers to cells B812
multiple to cells G9:J13

Until a choice is made both sets of cells remain blanked out (white text
using conditional format)
When a choice is made then that set of cells would show as black letters
(using conditional format) but only the range of cells that the choice
(single or multiple) refers to.

Is it possible to achieve the above with conditional formatting.

thanks

 

[Clif McIrvin]

in C2, 2 choices (menu) Single or Multiple

single refers to cells B812
multiple to cells G9:J13

Until a choice is made both sets of cells remain blanked out (white
text using conditional format)
When a choice is made then that set of cells would show as black
letters (using conditional format) but only the range of cells that
the choice (single or multiple) refers to.

Is it possible to achieve the above with conditional formatting.

thanks

Yes. Select either range of cells, then choose conditional formatting
and create a new rule with a fomula: =C2="Single" or =C2="Multiple" and
select your desired formatting, then select the other range of cells and
do the same.

C2="Single" will evaluate True or False, and conditional formatting will
be applied or not.

You will need two rules for each area - one as above, the other to give
you your white text on white background: =C2<>"Single" or
=C2<>"Multiple".

 

[SS]

Yes. Select either range of cells, then choose conditional formatting and
create a new rule with a fomula: =C2="Single" or =C2="Multiple" and
select your desired formatting, then select the other range of cells and
do the same.

C2="Single" will evaluate True or False, and conditional formatting will
be applied or not.

You will need two rules for each area - one as above, the other to give
you your white text on white background: =C2<>"Single" or =C2<>"Multiple".

Thank for the reply, I have started work on it.
When I apply then it only applies to the first cell in the range and not all
the cells.
ie B8 only
I have checked the cell range and that appears to be correct.

 

[SS]

Thank for the reply, I have started work on it.
When I apply then it only applies to the first cell in the range and not
all the cells.
ie B8 only
I have checked the cell range and that appears to be correct.

Think I got it now by using the $ in font of the cell $C$2 in cond
formatting formula

thanks

 

[Clif McIrvin]

Think I got it now by using the $ in font of the cell $C$2 in cond
formatting formula

thanks

That makes sense. When I tested in xl2010 it applied the same formula
to all selected cells. If you did a copy/paste format (paintbrush icon)
to drag the conditional formatting across the range the (relative
address) C2 would have changed in each cell, where the (absolute
address) $C$2 would not.

Glad it's working, and thanks for posting back!