Chuck,

Thanks for the offer, but 90% of the data is confidential (Social Security
records).
By the time I've stripped all the confidential data out there won't be much
left.
We use XP2K at work and this WB is shared over a network.
I haven't checked with any of my colleagues to see if it is red on their
machines.

Unlikely to be a virus as all our machines are regularly checked for viruses
(Virii?) and there are only two macros which only do sorting on another
sheet.
I haven't checked with my colleagues to see if it is red on their machines.

You've given me an idea though. If I strip it and send it to myself at home,
I can look at it in XL XP.
As I explained to David, It's not important, just puzzling.


Henry

"CLR" wrote in message
...
I don't understand Henry..........I just tested it again here on my XL2k
and
it changed both a standard colored font cell and a Conditional Formatted
cell............what version of Excel are you using? Maybe you have a
nasty
macro at work behind the scenes? If you still have the trouble tomorrow,
how about stripping confidential info out and sending me a copy with the
bad
cell in it to my home addy?

Vaya con Dios,
Chuck, CABGx3




"Henry" wrote in message
...
Chuck,

Tried that. Doesn't work!
Still red font.

Thanks anyway,

Henry

"CLR" wrote in message
...
Click on an empty unused cell..........
Then click on the Formatting paintbrush up in the tool bar.........
Then click on the errant Red-font cell..........

Vaya con Dios,
Chuck, CABGx3


"Henry" wrote in message
...
I have an XL2000 spreadsheet.
All the entries are in black font.
One cell is showing in red font
I've changed the cell formatting to black font but it still shows in
red.
I've copied over it a similar cell with black font but it still shows
red
font.
It's not important what colour it shows, but it's puzzling me how to
change
it back to black.

The only thing I've yet to try is to delete the cell, shift left and
re-enter the data.

Any one got any thoughts on this?

Henry