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?