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.

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.

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.