Forum Discussion
Conditional Formatting HELP
Hello, My name is Tyler, i would for a company that does several studies in capibility. They want me to make a form so that when we paste in the data the conditional formatting will highlight cel...
The issue that i am facing is that each column has a different tolerance which will change the rule, is there a way that i dint have to write 300 rules?
Tyler, with that formula it works for different tolerance in each column:
Key point is correct using of absolute and relative reference, see attached file.