conditional formatting error removal

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

[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




"JDog" wrote:

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

[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

On Fri, 20 Jan 2006 14:17:02 -0800, "JDog" <JDog@discussions.microsoft.com>
wrote:

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

[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?

[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

[jesahs]

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

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. Certain boxes have conditional colors that need to be able to appear - not just the color white. I've followed your suggestion and went to Format > Cells > Font > Color, and clicked automatic. Nothing happens.

[jesahs]

I figured it out. Thanks for all the help.