Your problem is that the text is actually black. The conditional format makes
it appear white. There is no easy way around this.
--
HTH...

Jim Thomlinson


"Homer" wrote:

I have multiple cells with multiple forms of conditional formatting. If a
certain cell has a number, the information in others will be visable and cell
will be shaded. If another cell is empty, another set of cells will not be
visable and not print. The text and cell shading is formatted to be white
via conditional formatting.

This works fine. But if I want to print B&W without shading I run into
trouble. I go into page setup then sheet and check B&W. When I do this all
text, even the text that should be white prints as black.

How do I remove the shading in all cells, but keep any white text to not
print?