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

I had this question after viewing looping through subform for specific  background color red and give me some type of alert.

I still have a problem evaluating the data in the subform correctly.  In the field "TARGET_GP"

percentage check
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%

Who is Participating?
Gustav BrockConnect With a Mentor CIOCommented:
Use the real numeric value in the rule:

Value <= 0.1499
- or, I guess:
Value < 0.15

Open in new window

Try removing the quotes:

<= 14.99
mbizupConnect With a Mentor Commented:
Or if this is truly TEXT and not a numeric field displayed with a percentage sign, you can try changing to 'Expression Is '  formatting, using the expression (with the field name in square brackets):
Val(replace([YourFieldName],"%","")) <=14.99

Open in new window

Dale FyeCommented:
I would agree with Gustav that you need to use the numeric value, not the displayed format.
FordraidersAuthor Commented:
Thanks all
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.