Sleeper: Hightlight each different number

[Dreamer]

Hi,
How can I hightlight the cell as RED when cell values in a column
(e.g column A) change?

ColA
1<-Hightlight
1
1
1
1
2<-Hightlight
2
2
2
3<-Hightlight
3

THANKS!

[Bob Phillips]

Hi,
How can I hightlight the cell as RED when cell values in a column
(e.g column A) change?

ColA
1<-Hightlight
1
1
1
1
2<-Hightlight
2
2
2
3<-Hightlight
3

THANKS!

Select A2:An
menu Format>Conditional Formatting
Change Condition1 to FormulaIs
Add A formula of =A2<>A1
Click Format and select your highlighting choice
Exit