Custom formatting

P

Pat

Does anyone know of a custom format I could use where the result of the
formula;

=AV31/AS31-1

returns #DIV/O!

Thanks
Pat
 
F

Frank Kabel

Hi
not possible with a custom format. Either use
=IF(AS31=0,"",AV31/AS31-1)

or use conditional formating and checking for
=ISERROR(cell_reference)
and assigning a white font
 
Top