Conditional formatting in Combination with an IFerror function

[FrankLinssen]

Hi,
I have a formula that calculates a rate for a certain article based on data on another sheet. It is possible that there is no data available for that article. Therefore I put my formula inside an IFERROR formula.

Is it possible to set up a conditional format in the case that the IFERROR is true / active? In other words, there was no data found for that article on the other sheet, the IFERROR steps in and shows a zero or something else (no matter what).

Only for these cases I want a conditional format to become active, so I can see that for that cell there was no rate-calculation possible and the IFERROR had to do its work...

 

[Scott Huish]

You could set up a Conditional Format with ISERROR(yourformula)