Sliding conditional formatting

Registration date
Tuesday November 27, 2018
Last seen
November 27, 2018
Hi everyone,
I am currently stuck in Excel with the conditional formatting. I would like to apply a color to a cell in column A, row 1 based on a formula referring to the value of another cell in the same row 1 but in a different column (for example B). Easy. But then, I would like to extend this formatting to all the cell of the column A, applying formatting based on the content of the reference cell in column B and in the same row (not the initial one). for instance I want to format
A1 based on B1
A2 based on B2
A3 based on B3
I keep trying but struggle with it. Excel keeps using my very first reference B1 as reference for all. I tried the copy/past function, the format painter, the extension, but nothing is working... I also tried with the $ to use the referential function, but did not manage either...

Can anyone help me?
Thanks so much!
See more 

1 reply

Registration date
Sunday September 12, 2010
Last seen
October 22, 2019
Thank you
Hi Mgrivetseyve,

Let's say you want to format column A, when the value in column A is bigger then the value in the corresponding cell in column B. You would like to do this for 10 rows:
Formula to use:
Applied range to use:

Best regards,

Respond to TrowaD