| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When I type an H in Excel, I need to to change to the colour red?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When I type an H in Excel, I need to to change to the colour red?
Look at Conditional Formatting in the main Format menu.
Regards, Peter T "Dave" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When I type an H in Excel, I need to to change to the colour red?
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 "Dave" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format Font Type(not colour) change | Excel Discussion (Misc queries) | |||
| How do I type in colour without having to change it every cell | Excel Discussion (Misc queries) | |||
| change colour of Excel title bar | Excel Programming | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| How do I change the cursor colour in Excel? | Setting up and Configuration of Excel | |||
Linear Mode
