(Excel) conditional formatting based on adjacent cell, whole column

Question

I'm trying to highlight the changes in a long list of data, so I would like to have the cell shaded if its value is different than the cell above. I can implement this for a single pair of cells using conditional formatting, but I can't get it to work for a whole column. Here's what I want it to look like (I performed this shading manually, for this example):

I tried this, but it doesn't propagate down the column when I select the column.

Answer 1

First time responding to a question on Stack Overflow, so apologies if the formatting on this response is messy.

You will want the formula to read: { =A2<>A1 }

Conditional Formatting Rules Manager