Conditional Formatting and REF#

[Meredith]

Is there a way to use conditional formatting so that REF# is invisible?

I've tried saying that if the cell is not between 1 and 10 million then the cell should have white font ( on a white background) but it's not picking the REF# up. I've also tried if it equals another cell that is REF#.

Why am I trying to do this? I am trying to find a work around for using ISERROR. I have a GETPIVOTDATA function in the cell, but there are some where there will be no data. I can say if(iserror(getpivotdata(blahblah)=true,0,getpivotdata(blahblhablha) but these kind of formulas just slow my computer way down and the files end up enormous.

 

[Doug.T]

Try this. Make the "Formula Is" in your conditional formatting...

=(ISERR(B2)=TRUE)

 

[Meredith]

Thanks Doug! that worked perfectly.