I'm having issues with conditional formatting not displaying correctly when comparing a Textbox field formatted as a percent to a textbox field (titled Target) with no format set but containing a percentage, e.g. 83%.
The Target field can contain either a number, a percentage, or text (yes or no). I have successfully set up conditional formatting to compare a textbox containing a number with a general format to the Target field with the help of the Val() function and I have successfully set-up comparing a combo box containing either a Yes or No to the Target field as well.
I set-up the first condition for the Percent field's expression as [Percent]<Val([Target]) to display in a red font, however, all of the fields are displaying in red even if the percent value is greater than the target. Any guidance as to what I'm doing wrong will be greatly appreciated. Thank you.