Formula for Conditional Formatting Based on the cell to the left

  • Hi all, I am looking to highlight each cell based on the value to the left. Hopefully without having to create a rule for every column. The example is if b2 is greater than a2, then it will be highlighted green. And if c2 is less than b2 it will be highlighted red and so forth. How would i do this?

  • Hi
    I realize this is quite an old thread, but maybe the answer will help someone else looking to do the same thing.
    The trick here would be to simply use relative references vs locked or A1 rather than $A$1

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!