Reputation: 175
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.
Upvotes: 0
Views: 1948
Reputation: 23
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
Upvotes: 1