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 cells out of spec. to do that i have to use 3 rules per column, and there are 100 columns. the rules are as follows,
If the numbers is above Tollarance, tuen cell red
If cell is below Tollareande , turn cell Green
IF cell is within tolarance turn blue.
The reason that i am here is becasuse i dont weant to have to this for all 100 columns becasue each column has a different set of tollerences. so copying the formatting over does not work.
Thanks for the help i will attach a file of what the sheet looks like.
Tyler
3 Replies
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.
