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?
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?