Conditional Formatting - Formula based on adjacent cells

[arun kumar]

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

	2
	45
	52
	45
	45
	45
	45
	45
	45

[#2]

Hi Arun,

You may apply conditional formatting rule with formula

=$B2<OFFSET($B2,-1,0)

to your range starting from second cell

and attached

[#3]

Thank you, this works perfectly. Appreciate your advice.

[#4]

@Mike_Ramirez_PhD , glad it helped