I have a number of worksheets referencing data pulls in other sheets. When I
finished developing the whole updatable template I realized there were some
cells with the common errors such as #REF!, #DIV/0!, etc...I am trying to
come up with a way other than 'IF' statements to either have the errored
cells return nothing or a dash or something other than the error itself. I
do not want to use IF statements because my reference cells and my data pull
are in a dfiferent order so I would have to enter each one individually. I
was thinking some type of conditional formatting or something, but have had
no luck in finding anything thus far. HELP!!!!

Thank you.

You can use CF and ISERROR to change the font to white but you would not be
able to use those cells in any calculations due to the errors.

Perhaps there is some pattern to the "different order" that OFFSET or INDEX
or similar function.........INDIRECT?.............. can handle.

Post some examples


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 15:50:02 -0700, Mike
wrote:

I have a number of worksheets referencing data pulls in other sheets. When I
finished developing the whole updatable template I realized there were some
cells with the common errors such as #REF!, #DIV/0!, etc...I am trying to
come up with a way other than 'IF' statements to either have the errored
cells return nothing or a dash or something other than the error itself. I
do not want to use IF statements because my reference cells and my data pull
are in a dfiferent order so I would have to enter each one individually. I
was thinking some type of conditional formatting or something, but have had
no luck in finding anything thus far. HELP!!!!

Thank you.

That is exactly what I needed. I just had to alternate rows with my
formating since I did the same thing with the fill colors. I do not need
them in calculations as I am only trying to set up a business review
scorecard. Thanks for your help, you truly are an Excel MVP.

"Gord Dibben" wrote:

You can use CF and ISERROR to change the font to white but you would not be
able to use those cells in any calculations due to the errors.

Perhaps there is some pattern to the "different order" that OFFSET or INDEX
or similar function.........INDIRECT?.............. can handle.

Post some examples


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 15:50:02 -0700, Mike
wrote:

I have a number of worksheets referencing data pulls in other sheets. When I
finished developing the whole updatable template I realized there were some
cells with the common errors such as #REF!, #DIV/0!, etc...I am trying to
come up with a way other than 'IF' statements to either have the errored
cells return nothing or a dash or something other than the error itself. I
do not want to use IF statements because my reference cells and my data pull
are in a dfiferent order so I would have to enter each one individually. I
was thinking some type of conditional formatting or something, but have had
no luck in finding anything thus far. HELP!!!!

Thank you.

Happy to have helped.

Gord

On Wed, 17 Jun 2009 16:28:01 -0700, Mike
wrote:

That is exactly what I needed. I just had to alternate rows with my
formating since I did the same thing with the fill colors. I do not need
them in calculations as I am only trying to set up a business review
scorecard. Thanks for your help, you truly are an Excel MVP.

"Gord Dibben" wrote:

You can use CF and ISERROR to change the font to white but you would not be
able to use those cells in any calculations due to the errors.

Perhaps there is some pattern to the "different order" that OFFSET or INDEX
or similar function.........INDIRECT?.............. can handle.

Post some examples


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 15:50:02 -0700, Mike
wrote:

I have a number of worksheets referencing data pulls in other sheets. When I
finished developing the whole updatable template I realized there were some
cells with the common errors such as #REF!, #DIV/0!, etc...I am trying to
come up with a way other than 'IF' statements to either have the errored
cells return nothing or a dash or something other than the error itself. I
do not want to use IF statements because my reference cells and my data pull
are in a dfiferent order so I would have to enter each one individually. I
was thinking some type of conditional formatting or something, but have had
no luck in finding anything thus far. HELP!!!!

Thank you.