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?

Participate now!

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