Condidtional formatting question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aksaunders@affiniongroup.com - 19 Jun 2006 18:50 GMT

Can someone help me please? I use a flowchart that shows numbers
either in black (meets minimum standards) or red (does not meet minimum
standards). Because I have formulas in every cell through the second
week of September, the cells for future weeks show 0.00%. Can someone
suggest a way to format the cells for future weeks to show as white
text so the numbers are not visible? I don't want to mess with the
formatting that changes text color from black to red.

Reply to this Message

David McRitchie - 19 Jun 2006 21:50 GMT

Conditional Formatting will override normal cell formatting
so if you make the text match the background it should not be a problem.
The values are not affected and if you remove it then it is gone.

But I think what you want to do can be done entirely with normal
cell formatting. If you simply want to suppress zero values
from showing. Make the third parameter empty (note two semi-colons on end)
i.e. 0.00%_);[Red](0.00%);;

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Can someone help me please? I use a flowchart that shows numbers
> either in black (meets minimum standards) or red (does not meet minimum
[quoted text clipped - 3 lines]
> text so the numbers are not visible? I don't want to mess with the
> formatting that changes text color from black to red.

Reply to this Message