Home

Conditional Formatting - Formula based on adjacent cells

arun kumar
Occasional Visitor

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
1 Reply

Hi Arun,

 

You may apply conditional formatting rule with formula

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

to your range starting from second cell

image.png

and attached

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies