View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default I want to hide #DIV/0

On Thu, 5 Jun 2008 10:15:01 -0700, Looping through
wrote:

How do I conditionally format a cell that returns the above error?

LT


For the conditional format formula, use:

=ERROR.TYPE(cell_reference)=2

and format the font color to be the same as the background color.
--ron