Mary,

What I do in some of my reports if a formula like

=IF(H12="Independent", " ",H12)

This would return a blank if H12 is Independent and if H12 is not
Independent, it would return the value for whatever is in H12. Hope this
helps.

Aleisha


"mary" wrote:

Hello,

I am trying to color text white (to essentially hide it) if it meets a
certain condition. However, it isn't as simple as if the cell =x. My If
statement includes recognizing text. =IF(H12="Independent", color text
white, color text black). Is there a way that I can use conditional
formatting in this case?