Conditional Formatting - Formula based on adjacent cells

Copper Contributor

I want to change the Color of the cell based on the adjacent cell.


I want to check the the value in cell 2 is less than cell1, if true Highlight the cell 2 in red and

check the cell 3 with cell 2 and Highlight the cell 3 if it is lesser.

Like this I want to do for 500 cells. It is not working if I use Format painter with conditional formatting.

Each time I Need to edit the formula to set the comparison with adjacent cells.


Pls help me to resolve the issue. Thank you in advance.


For example

3 Replies

Hi Arun,


You may apply conditional formatting rule with formula


to your range starting from second cell


and attached

Thank you, this works perfectly. Appreciate your advice.