Hiding Text With Conditional Formatting or better solution?

[slam]

I have some conditional formatting on a worksheet called R1 that changes the font color of G39 and H39:J39 (merged) if either of these conditions are met:

Setup!B5 = "No"
Setup!B5 = "Yes" AND Setup!B6 = "No"

The format change is that the font color changes to match the Fill color so that the text is essentially invisible.

The text remains invisible unless some cells are selected, in which case the Excel cell highlighting indicating they're selected, makes the text slightly visible due to the color change from selected cells.

This is an issue, because our process involves selecting a bunch of cells on the worksheet, and pasting them into MS Paint, to create a jpg of the sheet to post onto a forum on the internet.

Is there a better solution than my conditional formatting?

Thanks

EDIT: I should add, G39 is just text, but the merged H39:J39 is a data validation list pointing to Setup!H2:H21

 

[CWatts]

Use a conditional number format. Change it to Custom and set the rule to change the format format the cell as "";"";"";""

You can likely eliminate your white text formatting rule.

 

[slam]

Use a conditional number format. Change it to Custom and set the rule to change the format format the cell as "";"";"";""

You can likely eliminate your white text formatting rule.

Perfect! What exactly does that custom format mean in Excel terms? Thanks

 

[CWatts]

There are four sections and they relate as follows:

Positve;Negative;Zero;Text

So in the above example, it will blank out all of those, but you can tweak it depending on your needs:

$0.00;"< $0";"$0",@

Therefore, it will format any positive number as currency, any negative number will just display "< $0", but the real number is still there to do math on, the "$0" will just show that, and eliminate the two decimal format that the positive shows, and the @ means that if there is text in the cell, it won't override it. Trial and error. You can also use [RED] and [GREEN] to have the conditional formatting built into the number format.

 

[slam]

Thank you for the explanation. Much better than my original "solution"