Conditional Formatting

[Guest]

Hi,

I'm trying to "white out" the text in a cell if a certain value is displayed
(the cell has an existing formula in it already). What formula can I use in
the conditional formatting window to white out multiple (about 18) specific
values if they show up in the cell? And how do I maintain using my original
formula in this cell if the displayed value is not one of my 18.

Also, if I'm able to "white out" the cell described above, I need to "white
out" the cell next to it at the same time (which has a different formula
already in it). Can the formatting from the first cell be copied to the
second cell if the conditions are met in the first cell?

Help (and a BIG thank you!)

 

[Earl Kiosterud]

Trek,

For this example the cells to change color will be B2 and C2, depending on
the contents of B2.

Make a list somewhere with your 18 values, and name it MyList. It can be in
another sheet, and can be hidden (either the cells or the entire sheet). It
could even be right in the definition of the named range, though that's not
as good a way.

Select B2 and C2.
Format - Conditional formatting. Formula is: = OR($B2 = MyList)
Click the Format button, Font tab, and select the white font color. OK
OK again.

Note that you can do this with multiple rows at once, but the formula above
is for where the active (white) cell of your selection is in row 2. Change
the $B2 term accordingly if necessary.

 

[Guest]

Thanks so much Earl!!! It worked perfectly!

Trek,

For this example the cells to change color will be B2 and C2, depending on
the contents of B2.

Make a list somewhere with your 18 values, and name it MyList. It can be in
another sheet, and can be hidden (either the cells or the entire sheet). It
could even be right in the definition of the named range, though that's not
as good a way.

Select B2 and C2.
Format - Conditional formatting. Formula is: = OR($B2 = MyList)
Click the Format button, Font tab, and select the white font color. OK
OK again.

Note that you can do this with multiple rows at once, but the formula above
is for where the active (white) cell of your selection is in row 2. Change
the $B2 term accordingly if necessary.