Conditional Formatting in Excel comparing values in cell over multiple rows

Question

I have two columns Marks and Expected Marks, using conditional formatting i want to highlight all cells where marks are greater than expected marks in the same row. How to apply such conditional formatting over multiple rows.

user11222393 · Accepted Answer · 2023-01-27 10:16:14Z

0

Select marks cells, in conditional formatting choose "Format only cells that contains", then choose "Greater than" and choose first cell from expected marks column.

Result:

answered Jan 27, 2023 at 10:16

user11222393

5,6494 gold badges17 silver badges28 bronze badges

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

2 Comments

Manish Tripathi Over a year ago

This works for the first row, however B3, needs to be compared to A3, B5 needs to be compared to A5, and so on, this does not work in those scenarios

user11222393 Over a year ago

It works for all rows if you selected B column, it will automatically adjust a2 to a3 and so on. Just be sure that formula is =A2 ant not =$A$2

Collectives™ on Stack Overflow

Conditional Formatting in Excel comparing values in cell over multiple rows

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