I create and manage all of the quality control documents for my company in InfoPath 2007. I have been using the software for almost 2 years and have never come across an issue like this.
I am taking the user input, and performing this calculation ((((1741.38*0.5)+3.07)-input)*2). That value is then compared to minimum and maximum fields, if it is not within the tolerances of the min/max fields it is conditionally formatted to turn the cell red. However, for four of the lines that I am using this calculation, the cell turns red when it is equal to the max field value. I have checked all of conditional formatting, rules, etc... and they match the rows in which it funstionc properly. Is there something I am missing. Any help would be appreciated.