I am building a sheet where users enter data that must foot and cross foot. Using the conditional format (and all examples in this post are only selecting "applies to" a single cell), "format only cells that contain" then Cell Value, not equal to, =c25+d25-e25 and the format highlight fills in red. That way, if someone enters bad data, they'll know if before they send it to me. The problem I'm having is someone enters the formula, then it fine, but if they enter the results, then even if the answer is correct, it fills with red.
The same thing is happening when I try to "Use a formula to determine which cells to format", format values where this formula is true, =c7+d7-e7-f7<>g7. The same results. If you enter a formula into g7, its fine, if you enter a number that equals the results of the formula, it's not. We want users to enter the raw data, rather than a formula, though we can't stop them from using formulas, we just don't want to build something that forces them to do so.
Any ideas??
Bookmarks