Forum Discussion

Jwhittier's avatar
Jwhittier
Copper Contributor
Mar 01, 2022

Conditional formatting multiple columns

Is it possible, given an excel sheet with multiple analysis types separated by column, and provided a Lower control limit/upper control limit:  to use conditional formatting to turn the number Red if it falls outside of the control limit for it's column?  I can do this by creating a separate rule for each column, but I am looking to see if there is a way to program/logic it such that I can do one rule that will correctly look for the LCL/UCL? 

 

Screenshot is just made for example, Looking to do this at ones that have 15+ columns, where it would save alot of time to do one rule vs typing 15 separate rules.

 

 

 

Resources