PDA

View Full Version : Sleeper: Hightlight each different number



Dreamer
07-01-2005, 05:47 AM
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
07-01-2005, 05:52 AM
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