Hi!

Assume the data is in the range A1:B10

Select that range
Goto FormatConditional Formatting
Formula is: =ISERROR(A1)
Click the Format button
Set the font color to be the same as the background color
OK out

Biff

"CinqueTerra" wrote in message
...
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!