Change font color automatically
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. |
Change font color automatically
Select the cell and go to Format|Conditional Formatting apply: Cell Value is Equal to ="X" click Format and choose font colour. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126004 |
Change font color automatically
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. |
Change font color automatically
Thank you very much for the help.
On Aug 17, 8:25*am, NBVC wrote: Select the cell and go to Format|Conditional Formatting apply: * Cell Value is Equal to ="X" click Format and choose font colour. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile:http://www.thecodecage.com/forumz/member.php?userid=74 View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=126004 |
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 - |
Change font color automatically
I tried what you gave me; however, I wasn't successful (I was
uncertain on the first part where you said right click sheet tabview code?) I have excel 2007 if that makes any difference. Anyhow, I appreciate you taking the time to help me. I was able to use the other solutions given. Thanks again. Also, I have another problem I am trying to figure out. I will post it--- maybe you can help me. On Aug 17, 9:26*am, "Don Guillett" wrote: If you don't want a lot of CF then right click sheet tabview codeinsert this. Set to col E now. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 5 Or Target.Count < 1 Then Exit Sub Select Case LCase(Target) Case "x": mc = 3 Case "y": mc = 5 Case Else mc = 0 End Select * 'Application.EnableEvents = False Target.Font.ColorIndex = mc * 'Application.EnableEvents = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "dcb1" wrote in message ... 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 - |
Change font color automatically
|
All times are GMT +1. The time now is 07:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com