Oct 10 2018 06:21 AM
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 |
Oct 10 2018 06:36 AM
Hi Arun,
You may apply conditional formatting rule with formula
=$B2<OFFSET($B2,-1,0)
to your range starting from second cell
and attached
Nov 15 2022 09:54 PM
Nov 17 2022 01:56 PM
@Mike_Ramirez_PhD , glad it helped