software

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.

Once you've selected your range of cells, you'll notice that still only one
cell is quot;activequot;.

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

quot;JDogquot; wrote:

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

This method does not quot;removequot; errors.

It just hides or highlights them.

First select the range of cells to be formatted then Formatgt;CFgt;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, quot;JDogquot; gt;
wrote:

gt;I'm trying to remove all errors from my worksheet. I've read some other posts
gt;from people asking the same thing, and the responses have mentioned using
gt;ISERROR(A1) as the function, then after changing the color formatting for the
gt;cells, change to include all your cells. I've tried that by using
gt;ISERROR($A:$Z) and it doesn't work.
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?--
jesahs
------------------------------------------------------------------------
jesahs's Profile: www.excelforum.com/member.php...oamp;userid=30687
View this thread: www.excelforum.com/showthread...hreadid=503531I 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
Pete Wrote:
gt; I think you may have used the normal formatting to turn all cells
gt; white, rather than just the format panel which is presented to you in
gt; the conditional format box. If this is the case, highlight all cells
gt; by
gt; clicking on the intersection between row and column identifiers, then
gt; Format | Cells | Font | Colour and select automatic. Then see if your
gt; attempts to conditionally format have worked.
gt;
gt; Hope this helps.
gt;
gt; 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 gt; Conditional Formatting gt; Formula Is
3)Enter quot;=ISERROR(B8)
4)Click the quot;Formatquot; button
5)Select the color white and hit ok

Everything turns white except the numbers. I've followed your
suggestion and went to Format gt; Cells gt; Font gt; Color, and clicked
automatic. Nothing happens.--
jesahs
------------------------------------------------------------------------
jesahs's Profile: www.excelforum.com/member.php...oamp;userid=30687
View this thread: www.excelforum.com/showthread...hreadid=503531
I figured it out. Thanks for all the help.--
jesahs
------------------------------------------------------------------------
jesahs's Profile: www.excelforum.com/member.php...oamp;userid=30687
View this thread: www.excelforum.com/showthread...hreadid=503531