Change font color automatically
Thank you very much for the help--- it worked.
On Aug 17, 8:37*am, TGV wrote:
Using conditional formatting it can be done
1. Select the cell/Range
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter =a1="x"
4. Click Format ButtonFontColor select 'red' then give ok
Change a1 to ur desired cell.
--
If this post helps, pls click Yes
---------------
TGV
"dcb1" wrote:
When I select the letter 'X' from a drop down list, I want it to
display it in red automatically. *However, I don't want to have to
change the font color. *Therefore, each time I enter this character---
the font will be shown in red. *Anything else I choose from this list
will display in black (which of course is the default). *Is there a
way to do this? *Or, even if it is not from a drop down list, when I
enter a particular character in a cell--- I want it to show that
particular character in a specific color.- Hide quoted text -
- Show quoted text -
|