Invisible text with conditional formatting?

[HALBURN]

The "no fill color" option when applying conditional formatting to text does not work. Instead of making the text transparent it makes the text white. In the past I have worked around this problem by simply making the text the same color as the background. Unfortunately in my current solution the background is a photographic image so the workaround does not work.

 

Does anyone have a trick for dealing with this issue?

[Lee Smith]

How about making the text size 500 pts?

[HALBURN]

As ridiculous at that sounds, it seems to work. Thanks!

[dysong3]

Thanks a lot.  This put an end to a few hours of hair pulling frustration.

[HALBURN]

Thanks a lot.  This put an end to a few hours of hair pulling frustration.

I feel your pain.