View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default 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?