Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 2nd 12, 07:03 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 1
Red face 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

  #2   Report Post  
Old August 2nd 12, 08:43 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by LindzlBunzl View Post
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
Conditional Formatting is what you need.
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 06:17 AM
change text colour Jeff New Users to Excel 3 February 15th 06 06:53 AM
change a cell colour when entering a letter paul42770 New Users to Excel 2 June 27th 05 08:58 PM


All times are GMT +1. The time now is 03:51 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017