I am having trouble with my conditional formatting. I currently have the following rule
It works as long as G8 is blank. However it won’t work because I have an index match formula in G8 which is
So even though G8 is blank the conditional formatting is still picking up the formula as a value, how do I work around this??