Conditional formatting for entire Column based on another column

Question

I want to have a cell highlighted green if the next cell is greater than the current cell. This formatting should apply for an entire column.

E.g. if A2 > B2 then A2 should become green. If A3 > B3 then A3 should become green, and so on.

Note: I want to not have this done by individual formatting, but by a general rule.

Hey Kavin, I noticed this is your first question: Welcome to StackOverflow! I did some edits to your question because I had problems understanding it. I highly recommend you check out our guide How do I ask good questions? — Basti Funck
– Basti Funck, Commented Apr 13, 2020 at 18:12

basic · Accepted Answer · 2020-04-13 12:24:51Z

3

Go to Conditional formatting, add new rule with type Use a formula..., add formula =$A1>$B1, into Applies to add range =$A:$A. That's all.

answered Apr 13, 2020 at 12:24

basic

12k2 gold badges15 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

icedwater Jan 7 at 9:06

Trying to look for an equivalent solution in Excel for Teams but =$A:$A seems to be an invalid range... let me see if I can find something...

icedwater Jan 7 at 9:25

What worked for me is manually specifying A2:A5 as a range, though A:A seems to be the preferred format to refer to ranges if you don't have cell A1 as a header...

Collectives™ on Stack Overflow

Conditional formatting for entire Column based on another column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related