Home |
Search |
Today's Posts |
#1
|
|||
|
|||
change a cell colour when entering a letter
I am working in excel 2000, and I need to know how to change a colour of a
cell when I enter a letter. Ie, if I put y for yes in a cell, I want to change that cell to say red. |
#2
|
|||
|
|||
Use "Conditional Formatting"
Click on the cell, do Format ConditionalFormatting CellValueIs EqualTo Y FormatButton PatternsTab choose red color block OK OK Vaya con Dios, Chuck, CABGx3 "paul42770" wrote in message ... I am working in excel 2000, and I need to know how to change a colour of a cell when I enter a letter. Ie, if I put y for yes in a cell, I want to change that cell to say red. |
#3
|
|||
|
|||
Thanks
It was most helpful. Paul "CLR" wrote: Use "Conditional Formatting" Click on the cell, do Format ConditionalFormatting CellValueIs EqualTo Y FormatButton PatternsTab choose red color block OK OK Vaya con Dios, Chuck, CABGx3 "paul42770" wrote in message ... I am working in excel 2000, and I need to know how to change a colour of a cell when I enter a letter. Ie, if I put y for yes in a cell, I want to change that cell to say red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change cell color dependin on date ... | Excel Worksheet Functions | |||
How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
background color of my cell does not change | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Changing Cell Fill Colour | Excel Discussion (Misc queries) |