Using Conditional Formatting to Hide Error

**Gos-C** · 04-13-2005, 02:28 PM

Can I hide the #DIV/0! ERROR in cells F8, H8, I8 by using conditional formatting (font colour) in only these cells? If so, how?

Thanks,
Gos-C

**swatsp0p** · 04-13-2005, 02:45 PM

In Conditional Formatting... for this cell, set Formula Is: to

=ISERROR($F$8)

Set Format to Font color of White
--------------------------
Another option is to test for the error with an IF statement and return an empty string "" if there is an error, e.g.:

=IF(ISERROR(F7/F6),"",F7/F6

assuming you are dividing F7 by F6, adjust as needed.

This avoids the need for conditional formatting

HTH

Bruce

**Gos-C** · 04-13-2005, 02:57 PM

Hi Swatsp0p,

Thanks, I highlighted the range and use relative cell reference -- it works. I did not want to used "" as the cells are included in Sum formulas.

Gos-C

**swatsp0p** · 04-13-2005, 04:54 PM

If you SUM a range containing a #DIV/0! error, your sum will result in #DIV/0!

If you use my formula, the cell will be treated as a zero and will not affect your SUM range (unless, of course, you want the SUM to fail if you have a #DIV/0! error)

HTH

Bruce

Using Conditional Formatting to Hide Error

LinkBack

Thread Tools

Rate This Thread

Display

Using Conditional Formatting to Hide Error

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions