<div>
Maybe it should be:<br />
<br />
=$X215&gt;0<br />
<br />
(if it's not blank, and assuming a number, then it will be greater than 0, so only need the one statement.<br />
<br />
To combine with first formula:<br />
<br />
AND($Q215=&quot;APPROVED&quot;,$S215<wbr />=&quot;&quot;,$X215&gt;<wbr />0)
</div>


Maybe it should be:

=$X215>0

(if it's not blank, and assuming a number, then it will be greater than 0, so only need the one statement.

To combine with first formula:

AND($Q215="APPROVED",$S215="",$X215>0)

<div>
<div class="content wysiwyg-content">
I am using the following formula in Conditional Formatting:<br />
<br />
AND($Q215=&quot;APPROVED&quot;,$S215<wbr />=&quot;&quot;) and it works for what I am trying to do.<br />
<br />
Now I need another formula to see if X215 is greater than zero or not blank. I tried to use: <br />
<br />
AND($x215=&quot;&lt;&gt;&quot;,$S215=&quot;&quot;) &nbsp;but it shaded my entire range green....<br />
<br />
How would I combine the two formulas together. I need it to turn green if q215 says approved OR X215 has a value in it...
</div>
</div>


I am using the following formula in Conditional Formatting:

AND($Q215="APPROVED",$S215="") and it works for what I am trying to do.

Now I need another formula to see if X215 is greater than zero or not blank. I tried to use: 

AND($x215="<>",$S215="")  but it shaded my entire range green....

How would I combine the two formulas together. I need it to turn green if q215 says approved OR X215 has a value in it...

I need a conditional formatting formula

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