2) I have a row of numbers in collumn C.

eg

1. 1111

2. 1111

3. 1111

4. 1121

5. 1121

6. 1132

In collumn D i need the cell to turn black when the number changes. So in my case cells C3, C5 and C6 should turn black. Is there a formula for conditional formating to allow this.

Many thanks

Thanks in advance