If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change Font Color when I type the letter
I need to know how to set up a function (maybe) to change
the font color when I type the letter. For example, I have a field (column) contains Femal and Male information. I need to change M in color "Blue" when I type M in the column; change F in color " Red" when I type F in the column. Please help and thanks! |
#2
|
|||
|
|||
Change Font Color when I type the letter
Use conditional formatting (FormatConditional Formatting), and test the
values equal to M and F and set the colour accordingly. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Anne Fu" wrote in message ... I need to know how to set up a function (maybe) to change the font color when I type the letter. For example, I have a field (column) contains Femal and Male information. I need to change M in color "Blue" when I type M in the column; change F in color " Red" when I type F in the column. Please help and thanks! |
#3
|
|||
|
|||
Change Font Color when I type the letter
Hi
Select column. From menu select Conditional Formatting Condition1: Cell value is - equal to - M Seelect Format and set font color to blue Add Condition2: Cell value is - equal to - F Seelect Format and set font color to red OK -- Arvi Laanemets (Don't use my reply address - it's spam-trap) "Anne Fu" wrote in message ... I need to know how to set up a function (maybe) to change the font color when I type the letter. For example, I have a field (column) contains Femal and Male information. I need to change M in color "Blue" when I type M in the column; change F in color " Red" when I type F in the column. Please help and thanks! |
#4
|
|||
|
|||
Change Font Color when I type the letter
I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue.
Thank you, Enterprise Project Consulting |
Thread Tools | |
Display Modes | |
|
|