Custom formatting

[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

 

[Guest]

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