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.
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.