help with format / formula

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

in C2, 2 choices (menu) Single or Multiple

single refers to cells B8:D12
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
 
SS said:
in C2, 2 choices (menu) Single or Multiple

single refers to cells B8:D12
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
Click to expand...


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".
 
Clif McIrvin said:
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".
Click to expand...
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 said:
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.
Click to expand...
Think I got it now by using the $ in font of the cell $C$2 in cond
formatting formula

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

thanks
Click to expand...

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!
 
Back
Top