<div>
Try this<br />
<br />
=(G8&gt;H8)*(G8&lt;&gt;0)<br />
<br />
instead of<br />
<br />
=(G8&gt;H8)*(LEN(G8)&lt;&gt;0)<br />
<br />
Sid
</div>


Try this

=(G8>H8)*(G8<>0)

instead of

=(G8>H8)*(LEN(G8)<>0)

Sid

<div>
Thanks for the suggestion Sid but it still isn't working, I am getting the same result.
</div>


Thanks for the suggestion Sid but it still isn't working, I am getting the same result.

<div>
PERFECT!!, thank you so much for your help Sid!
</div>


PERFECT!!, thank you so much for your help Sid!

<div>
You are welcome :)<br />
<br />
Sid
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am having trouble with my conditional formatting. I currently have the following rule <br />
=(G8&gt;H8)*(LEN(G8)&lt;&gt;0)<br />
<br />
It works as long as G8 is blank. However it won’t work because I have an index match formula in G8 which is<br />
<br />
=IF(ISERROR(INDEX(‘example<wbr />'!$A$5:$U$<wbr />97,$A8,G$2<wbr />)),&quot; &quot;,INDEX('example'!$A$5:$U$<wbr />97,$A8,G$2<wbr />))<br />
<br />
So even though G8 is blank the conditional formatting is still picking up the formula as a value, how do I work around this??<br />

</div>
</div>


Hello,

I am having trouble with my conditional formatting. I currently have the following rule 
=(G8>H8)*(LEN(G8)<>0)

It works as long as G8 is blank. However it won’t work because I have an index match formula in G8 which is

=IF(ISERROR(INDEX(‘example'!$A$5:$U$97,$A8,G$2))," ",INDEX('example'!$A$5:$U$97,$A8,G$2))

So even though G8 is blank the conditional formatting is still picking up the formula as a value, how do I work around this??


Conditional Format Help

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.