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.
You may apply conditional formatting rule with formula
to your range starting from second cell