Home

Conditional Formatting - Formula based on adjacent cells

Highlighted
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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies