Hi there - hopefully an easy one but I can't figure it out!!!
I have an Excel report with a range that only populates a figure if there is data to show else it's blank (using an iferror linked to other cells) but I also want the cell to be filled with a colour when there is a figure displayed. I tried Conditional Formatting with an if(not(isblank type thing, but because the cell contains as an iferror at all times, the formatting is always there.
Any ideas?
Bookmarks