Font color changing by itself
 

I have worksheets that I have been using for quite awhile. Recently the font
color in one column sometimes comes up as red. I go in and change it back to
black but later it goes back to red. I can't find what might be making it
change. I do used custom views on the worksheet and after I change the color
to black I save the view but sometimes it still goes back to red.
Anyone Know What I'm doing wrong?

Font color changing by itself
 

Check for conditional formatting on the cells in question.

or Change the value to something which shows up correctly and see... If this
happens then conditional formatting may be the problem

I am not familiar with custom views - they may be the problem too

"EJamison" wrote:

I have worksheets that I have been using for quite awhile. Recently the font
color in one column sometimes comes up as red. I go in and change it back to
black but later it goes back to red. I can't find what might be making it
change. I do used custom views on the worksheet and after I change the color
to black I save the view but sometimes it still goes back to red.
Anyone Know What I'm doing wrong?

Font color changing by itself
 

Check Format/ Cells and Format/ Conditional Formating.
--
David Biddulph

"EJamison" .(donotspam) wrote in message
...
I have worksheets that I have been using for quite awhile. Recently the
font
color in one column sometimes comes up as red. I go in and change it back
to
black but later it goes back to red. I can't find what might be making it
change. I do used custom views on the worksheet and after I change the
color
to black I save the view but sometimes it still goes back to red.
Anyone Know What I'm doing wrong?