On Wed, 26 Oct 2005 11:05:08 -0700, "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!

Select the range of cells that need to be formatted.

Format/Conditional Formatting:

Formula Is:
=ERROR.TYPE(cell_ref)=4

(Replace cell_ref with the selected active cell)

Format/Font and select Color: White

OK
OK


--ron