Hi can anybody tell me how to conditional format complete columns? I want adjacent columns to format dependant on cell value. I.e: if column A is lower than B it colours red and if is higher it colours green. I have a lot of data in the columns so and can do cells myself but not columns.

Thanks for any help.