1) What formula do i need to use in conditional formating to turn cell B1 black if cell A1 says "Specified".
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
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