Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing font or fill-color when using formulae Phil Excel Discussion (Misc queries) 1 April 4th 08 01:02 PM
Changing Font color based on font type or size John Excel Discussion (Misc queries) 2 February 7th 08 12:50 AM
changing color of font to words in a list Carl Excel Discussion (Misc queries) 0 March 12th 07 11:29 PM
Changing Font Color bagoxc Excel Discussion (Misc queries) 2 July 17th 06 01:14 AM
changing font color for new text DanDavis Excel Discussion (Misc queries) 2 July 24th 05 04:17 PM


All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"