|
| 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
August 2nd 12, 07:03 PM
|
|||
|
|||
Can I change text colour according to the letter entered?
Hello,
I only have a vague awareness of formatting and am quite new to the whole Excel thing. I have created a spreadsheet for work on which I have a column which users will enter 'Y' or 'N' into. Is there anyway that when the 'y' is entered that the test would go red and bold? I have tried searching various forums for help but can't seem to find anything! Cheers Lindzl 
|
| Ads |
|
#2
August 2nd 12, 08:43 PM
|
|||
|
|||
Quote:
Post an example workbook and I'll show you how, but it's easy enough to work out by googling it and working through an example or two.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how do I Change cell fill colour by placing letter in it | Spreadsheetdimwit | Excel Discussion (Misc queries) | 3 | July 22nd 07 01:20 PM |
| Add text change row colour | Sue | Excel Programming | 2 | July 15th 07 06:44 PM |
| Why did text in entered formula change to red in Spreadsheet | TartanMaid | Excel Worksheet Functions | 2 | January 25th 07 05:17 AM |
| change text colour | Jeff | New Users to Excel | 3 | February 15th 06 05:53 AM |
| change a cell colour when entering a letter | paul42770 | New Users to Excel | 2 | June 27th 05 08:58 PM |
Linear Mode
