Conditional Formatting Referencing a Cell


I feel that this is something there isn't functionality for, but I wanted to check and see if I may just be missing something.

Right now, I have a list of a numbers in a column and then have it calculating the average, upper limit (the average + standard deviation), and lower limit (the average - standard deviation).

What I want to do is use conditional formatting to highlight cells in the above column of numbers if it's above the upper limit or below the lower limit. Is there a way to do that? I tried to create the rule, select "is greater than" and then type in the cell number, but that doesn't do anything.

Is there another way to set this up? Or would it have to be manual entry of the number in the conditional formatting and then update that as the upper and lower limit changes?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!