I am trying to setup my spreadsheet so that one column will colour code based on the values in the previous column. I can work out how to create the conditional formatting to make it work for one row but I don’t know how to make it work for any row.
You may use conditional formatting rule with the formula used relative reference on previous column. Let say your range is in columns B:G and you'd like to highlight values which are greater than ones in previous column. When rule formula will be