Conditional Formatting across multiple rows

[Mitch_Frei]

I'm wondering if I can use one conditional formatting rule that can apply to different cells in the given range. For example, I want to highlight the cells in column 2 red if they are greater than their corresponding values in column 1 (the values to the left of them). In my example cells B2, B3, B5, etc. would be highlighted red. Can I do this with one rule or do I need a separate rule for every cell in column 2? I realize I could probably accomplish this with VBA, but I'm wondering if I can use one rule in conditional formatting. Thanks!

 

[#2]

@Mitch_Frei 

=B2>A2

This rule for CF works well in my spreadsheet.

[#3]

@OliverScheurich 
Where did you set the formula?

[#4]

Thanks! I was trying to do that in Rule Type "Highlight Cells with Value Greater Than" but once I selected the formula rule type that worked.

[#5]

@Denevita 

Conditional formatting -> new rule 

Please see attached file.

[#6]

Thank you :)