Changing Text Color After Change

T

Todd

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
 
V

Vasant Nanavati

Look at Format | Conditional Formatting. Set the color to red only of the
cell contains the text "[Enter text]".
 
B

Bob Phillips

Use conditional formatting, and set the value to not equal to "[Enter
Text]" and set the colour.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Hi
why don't you use conditional formating. Try the following
- select the cell (lets assume A1)
- enter the comparison that cell <> "[Enter Text]"
- chose your format (black)
- enter a second condition for cell = "[Enter Text]"
- choose your format (red)
 
T

Tom Ogilvy

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

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

Todd

Thanks to both of you...that was too obvious. It's always
the simple things *sigh*
-----Original Message-----
Use conditional formatting, and set the value to not equal to "[Enter
Text]" and set the colour.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

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
Click to expand...


.
Click to expand...
 
Top