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.