Why Excel Conditional Formatting does not work the same as formula? I have a couple thousand rows in a file. Column A has
AAA value, column B has
Column A Column B row1 1000 10 row2 2000 20 row3 3000 30
If I want to write a formula
A1*B1 it will give a result 10000. When I drag it, it will automatically change source cells so it would give me
A2*B2 = 40000.
So why conditional formatting doesn't do exactly the same when you copy formatting to different cell/row?
What I want to do is to set conditional formatting for each row separately:
x1.row1 > x2.row1 – make it green.
for second row:
IF(x1.row2 > x2.row2) – make it green,
for third row it should be:
IF(x1.row3 > x2.row3) make it green, and so on,
But Excel for every next row, compares always to first cell i.e.
x1.row1 > x2.row2,
x1.row1 > x2.row3 and so on.
Is there a way to apply formatting for each row separately, without creating multiple conditions?