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

1 Reply

Hi Arun,


You may apply conditional formatting rule with formula


to your range starting from second cell


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