Hi all - so I have two columns: "scenario 1" and "scenario 2." Within each column, I have probably 150 rows with costs in them. I want to write a formula that it would check the two scenarios together and let me know for instance if there's a value in column 1 (or scenario 1) which is less than its adjacent cell in column 2 or (scenario 2):
Scenarios
1 2
4589 2278
2278 2278
2278 2278
2278 2278
2278 2278
2278 2278
2278 2278
2278 2278
2278 2278
2278 2278
2278 2278
2278 2278
2278 2278

So for instance, I want the formula to "flag" this since the first row of column 1 is higher than the one for column 2.

Any suggestions on this?

Thanks a lot!