excel problem

[Davi]

Got sent a worksheet ages ago from somewhere, just tried to use it to get some data out only for some reason a loads of fields have had the colour of the text set to white - not very helpful when you try and print it off...

I've disabled the protection, I've checked the cells aren't hidden, and aren't themselves protected, but for some reason the text remains white and refuses to change!

Any ideas?

[2 sMoKiN bArReLs]

Have you tried changing the background to red?

[Davi]

LOL yeah won't let me change the background either - won't let me change anything in the cells that have white text other than the value!

[2 sMoKiN bArReLs]

Open new file, cut & paste data into it, and try changing?

[Davi]

Done, no joy there either! I know the spreadsheet is full of macro's - that's why I'm using it - but can't find anything there that is doing it

[Davi]

Ahhh - it's OK, I've got it - conditional formatting used! Doh!

[2 sMoKiN bArReLs]

Davi said:

Ahhh - it's OK, I've got it - conditional formatting used! Doh!

Oh yeah! Doh!