Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Changing Text Color After Change

Make them red using conditional formatting testing for the text "[Enter
Text]"

then when that is removed, you should get the default formatting.

--
Regards,
Tom Ogilvy

"Todd" wrote in message
...
I have a group of cells which contain the text "[Enter
Text]" and their color is set to Red. I would like the
text of these cells to change to Black after the new text
is entered in each cell.

I've been able to make them ALL change after the first
cell is changed, but I would like them all to change
seperately. Any suggestions?

TIA



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 ChartTypes will not change the color of the Series EAB1977 Charts and Charting in Excel 2 March 12th 10 02:09 PM
Changing row color for each change in col A Michael[_6_] Excel Discussion (Misc queries) 3 January 23rd 09 03:21 AM
Changing several cells text color lauras03 Excel Discussion (Misc queries) 1 March 12th 07 11:03 PM
How do I change formula results by changing the text color of the bailfire13 Excel Discussion (Misc queries) 4 May 31st 06 04:41 PM
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 04:55 PM.

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

About Us

"It's about Microsoft Excel"