Conditional Formatting if Cell <> Cell Above

Question

I'd like to apply a Fill colour to a cell, if it has a different value to the cell above it (same column).

I could do that for one cell, by using Conditional Format Rules

• Apply to range = target cell
• Format rules = If not equal to
• Value or formula = previous cell

However, the formatting failed when I dragged the cell down through the column (the range) so they would all get the same formatting - it always referenced the original Value, instead of using the "cell above this one".

Answer 1

In conditional formatting you do not have to drag down a cell.
Instead you need to apply it in a range.