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"
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%