ExcelBanter - Custom formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Custom formatting (https://www.excelbanter.com/excel-discussion-misc-queries/2013-custom-formatting.html)

Pat

Custom formatting

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

=AV31/AS31-1

returns #DIV/O!

Thanks
Pat

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

"Pat" wrote:

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

=AV31/AS31-1

returns #DIV/O!

Thanks
Pat

All times are GMT +1. The time now is 08:18 PM.