Conditional Formatting on cell with Indirect Formula

[Kate1]

Using this formula in a cell ($D8): =IFERROR(INDIRECT("'"&A32&"'!$F$16"),"") to return a value and this works well. My issue is in relation to formatting/highlighting the cell if a value is not returned. To explain, if the cell ($D8) returns a value which is > the value of another cell ($H$5) then I want to format/highlight that cell. If the cell ($D8) does not return a value, then I don’t want that cell to be formatted/highlighted.
In Conditional Formatting I am using Format only cells that contain, Cell Value, Greater Than, the cell $H$5, then the format highlights a colour even though the INDIRECT does not return a value. I have tried many different things, including Use a formula to determine which cells to format, the AND function, etc. and now need some further assistance. Can anyone help?

 

[Yongle]

D8 value is deemed by Excel to exceed value in H5
- likely cause is an invisible text string

Try this

Select cell D8 \ click on Conditional Formatting \ Manage Rules \ Edit rule \ Use Formula...

Paste formula below into Format values where this formula is true
=AND(D8>H5,D8<>"")

 

[Kate1]

Perfect! Thanks so much and appreciated.

 

[Yongle]

Thanks for the feedback