When I type an H in Excel, I need to to change to the colour red?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Iam trying to do a nattendance spread sheet in excel 2000. I need to use
three letters S for Sick,H for Holidays and T for training. I need it so when
someone enters a letter into the cell,it will change to a colour of my
choice. Can you help please? and give me a basic run down on how to do this.
Thanks

DW
 
Look at Conditional Formatting in the main Format menu.

Regards,
Peter T
 
Hi,

Select your cell or range of cells then:-

Format|Conditional format

Select Cell Value|Equal to and type your letter in the next box and select a
colour.

Click Add and do the second letter and then add again for the third. Click OK.

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem printing red coloured fonts in Excel 1
Excel Colour code dates 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Excel How to change lines in graph to individual colours 0
A challenge 2
Count Conditional Formatting Colours - Excel 2003 4
Change tab colour for active sheet 6
4 alternatives to all questions need randomization 1

Back
Top