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 BBB
value.
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?