| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Text Color After Change
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) -- Regards Frank Kabel Frankfurt, Germany Todd wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing ChartTypes will not change the color of the Series | Charts and Charting in Excel | |||
| Changing row color for each change in col A | Excel Discussion (Misc queries) | |||
| Changing several cells text color | Excel Discussion (Misc queries) | |||
| How do I change formula results by changing the text color of the | Excel Discussion (Misc queries) | |||
| changing font color for new text | Excel Discussion (Misc queries) | |||
Threaded Mode
