Forum Discussion
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...
=(B8<B$4)+(B8>B$5)Maybe with this rule for conditional formatting as shown in the attached file.