Sanjo
Sanjo

Reputation: 175

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

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):

column

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

format

Upvotes: 0

Views: 1948

Answers (1)

tacuba
tacuba

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

Related Questions