Highlight the cell if greater than value in the next column

So I tried experimenting with conditional formatting, but unable to find a way to highlight the cells in the column if their value is greater than the one in the next column under the same row.

For example:

102 | 110 (highlight right cell)
130 | 120 (highlight left cell)
122 | 133 (highlight right cell)

How would I go about doing this?

2 Answers

Here are the steps for Excel. Assuming the first value is in A1,

• select A1 to B3
• click Conditional Formatting > New Rule
• click Use a formula to determine

• enter this formula into the formula box and take care with the dollar signs

  =A1=MAX($A1:$B1)

• Click the Format button and set the desired format.

• confirm all dialogs.

In Google sheets, select the cells, create a conditional format with "Custom formula is" and apply the same formula.

Sorry, didn't see the Excel tag, only the Google Spreadsheets. This example is for Google Sheets. The concept is identical, but the wording may be different for Excel.

Use conditional formatting.

• In the left column, select your range (eg A1:A3) then under Format select Conditional Formatting.
• Select the Formatting Style greater than
• In the "Value or formula" field enter `=B1'

Repeat for column B, referencing cell A1.