Colour coding

[oconnells]

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.

[#2]

@oconnells 

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

=B1>A1

and the rule applied to the range $B:$G

[#3]

Thanks for the reply. How do I set this up? I know where to put the formula. Where do I put the range?

[#4]

@oconnells 

Select you range and apply CF rule using formula for the top left cell of the range. It will be applied to entire range automatically. However, you may always correct it.

Please check in attached.

[#5]

Thanks for your help. I have followed the instructions but it’s not working. When I click apply and come off the rules and then go back in, the dollar signs have been removed. Any idea why?

Also I do not have columns as letters - I have R4C8 does this affect the formula that I need to put in?

[#6]

Sergei - I have done it. You have no idea how grateful I am

[#7]

@oconnells , great, glad to know you sorted this out. Good luck with your project.