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...
Hi Tyler,
I didn't catch exactly what's what in your tables, let do one "Red" rule. Assume upper bound for Tolerance is in row 11, different for each column. Left up corner for your table is B14.
Then use the rule in conditional formatting
=(B14>B$11)
(be sure about absolute and relative references), format it in red and apply the rule to all your cells, i.e. to
=$B$14:$CW$
Similar for next two rules.
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.