<div>
Try removing the quotes:<br />
<br />
&lt;= 14.99
</div>


<div>
I would agree with Gustav that you need to use the numeric value, not the displayed format.
</div>


I would agree with Gustav that you need to use the numeric value, not the displayed format.

<div>
<div class="content wysiwyg-content">
I had this question after viewing <a href="https://www.experts-exchange.com/questions/29063521/looping-through-subform-for-specific-background-color-red-and-give-me-some-type-of-alert.html" rel="ugc">looping through subform for specific &nbsp;background color red and give me some type of alert</a>.<br />
<br />
<br />
I still have a problem evaluating the data in the subform correctly. &nbsp;In the field &quot;TARGET_GP&quot;<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/03_w12/1288819/conditional-format_percentage.bmp" target="_blank" title="percentage check (245 KB)"><img alt="percentage check" class="file-block lazyload" style="max-width: 558px;" data-src="https://filedb.experts-exchange.com/incoming/2018/03_w12/1288819/conditional-format_percentage.bmp" /></a><br />
The data shows up with a percent sign in the field. I have no way around this issue.<br />
<br />
So if any value in the field/column &nbsp;&quot;TARGET_GP&quot; IS BELOW &nbsp; 14.99% &nbsp;it will background the cell to red color.<br />
<br />
it is not color coding any -negative values.. or &nbsp;sometimes anything below 14.99%<br />
<br />
Thanks<br />
fordraiders
</div>
</div>


conditional-format_percentage.bmp

I had this question after viewing looping through subform for specific  background color red and give me some type of alert (https://www.experts-exchange.com/questions/29063521/looping-through-subform-for-specific-background-color-red-and-give-me-some-type-of-alert.html).


I still have a problem evaluating the data in the subform correctly.  In the field "TARGET_GP"



The data shows up with a percent sign in the field. I have no way around this issue.

So if any value in the field/column  "TARGET_GP" IS BELOW   14.99%  it will background the cell to red color.

it is not color coding any -negative values.. or  sometimes anything below 14.99%

Thanks
fordraiders

it is not color coding any -negative values.. or  sometimes anything below 14.99%

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.