Excel Formula Display

From the way they are describing it I have to specifically white out each cell.

"In the box on the right, type =ISERROR(reference), where reference is a reference to the cell that contains the error value."

When they wrote "reference to the cell that contains..." it means, on a gramatical level, that I have to specifically refer to the cell I want to white out without any degree of speficicity.

I'm guessing that this is just sheer inability to express themselves as it seems a very complex way of just changing text colour to white - I have tried doing what I thought they were suggesting (for the whole column/workbook/etc selecting a conditional formatting of formula is =ISERROR(#NUM!)) but that just changes everything to white so clearly they are both not explainging themselves well, as I haven't understood, or they are just being strange.
 
Last edited:
Right - I've played about with the conditional formatting and it seems that it should be able to do what I want just not the way that Microsoft have described it.

As I don't seem to be able to use google properly this probably is more a testament to my incompetence than anything else but the Microsoft explanation leaves a lot to be desired.
 
Nefarious said:
Ah, I've just worked out how to do it. Please excuse the noise... that's the sound of me eating my words............
Click to expand...
Oooh how'd you do it? I did try the Conditional Formatting trick myself but that didn't work for me.
 
It would seem that where you place =ISERROR(reference) you have to specifically refer to the formula that you want to have formatted (even then it allows only limited formatting and will not even allow you to change font size!).

So... if you have a series of formulas in a column where B$/M$ keeps giving you error values you type =ISERROR(B$/M$) or whatever the formula is - mine was to do with date values.

Thanks for finding the link - it was useful even if M$ can't explain themselves, the searches I tried on google were far more miss than hit
 
Ah righty ho. So you have to define what error you will be encountering and therefore want to hide? Hmm, why can't we have some kind of suppress errors option? If not a global one, then perhaps one that can be manually applied to cells, like the conditional formatting.
 
Agreed - I think they should allow more functionality to what they did put in too.

Why limit it so much? Would changing the font really be that much trouble???
 
Try somthing like this:

Code: 
=IF(ISERROR(E15*36/D15)^2,"",(E15*36/D15)^2)

If the formula produces an error then the cell is blank otherwise it shows the result.
 
You must log in or register to reply here.
Back
Top Bottom