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.
