In Conditional Formatting, change the type to "Formula" and enter:
=IsError(A1) Then change your font color.

Replace A1 with whatever cell contains the data you're checking.


"CinqueTerra" wrote:

I am populating a report with GetPivotData. If the data does not exist in
the Pivot, #REF! is returned. Is there a way to use Conditional Format to
change the font to white when #REF! is returned by the formula?

Thanks in Advance!