conditional formatting error removal

J

JDog

I'm trying to remove all errors from my worksheet. I've read some other posts
from people asking the same thing, and the responses have mentioned using
ISERROR(A1) as the function, then after changing the color formatting for the
cells, change to include all your cells. I've tried that by using
ISERROR($A:$Z) and it doesn't work.
 
E

Elkar

Once you've selected your range of cells, you'll notice that still only one
cell is "active".

When you enter your Conditional Format formula, it applies to that active
cell. Excel will copy that formula to all other select cells, incrementing
accordingly.

So, just using =ISERROR(A1) should work for all selected cells.

HTH,
Elkar
 
G

Gord Dibben

This method does not "remove" errors.

It just hides or highlights them.

First select the range of cells to be formatted then Format>CF>Formula is:

=ISERROR(A1) and change the color to white if you want the cells to look blank
or a color if you want to highlight the error cells.

All cells in the selection will have this formatting.


Gord Dibben MS Excel MVP
 
J

jesahs

I'm having difficulty logging in as JDog - my original name, so I'm
going to use this one for now.

I've tried your suggestions, but none of them seem to work, and all
that happens is that the colored cell formatting throughout the sheet,
turns to white.

My first cell which has any calculations is B8. I've selected all cells
from B8 to AF137 and used =ISERROR(B8) in place of =ISERROR(A1) in
Conditional Formatting. Does not work.

I've selected all cells from A1 to AF137, used =ISERROR(A1) in
Conditional Formatting. Still does not work.

What am I missing?
 
P

Pete

I think you may have used the normal formatting to turn all cells
white, rather than just the format panel which is presented to you in
the conditional format box. If this is the case, highlight all cells by
clicking on the intersection between row and column identifiers, then
Format | Cells | Font | Colour and select automatic. Then see if your
attempts to conditionally format have worked.

Hope this helps.

Pete
 
J

jesahs

Pete said:
I think you may have used the normal formatting to turn all cells
white, rather than just the format panel which is presented to you in
the conditional format box. If this is the case, highlight all cells
by
clicking on the intersection between row and column identifiers, then
Format | Cells | Font | Colour and select automatic. Then see if your
attempts to conditionally format have worked.

Hope this helps.

Pete
Click to expand...

I've done exactly that and my cells still end up being white.

Here's what I'm doing, step by step:

1)Select all cells that contain formulas, from B8:AF137
2)Go to Format > Conditional Formatting > Formula Is
3)Enter "=ISERROR(B8)
4)Click the "Format" button
5)Select the color white and hit ok

Everything turns white except the numbers. I've followed your
suggestion and went to Format > Cells > Font > Color, and clicked
automatic. Nothing happens.
 
Top