Forum Discussion
Conditional Formatting - Formula based on adjacent cells
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 ...
Hi Arun,
You may apply conditional formatting rule with formula
=$B2<OFFSET($B2,-1,0)
to your range starting from second cell
and attached
- Thank you, this works perfectly. Appreciate your advice.
Mike_Ramirez_PhD , glad it helped
