change a cell colour when entering a letter

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

Guest

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
Click to expand...


Vaya con Dios,
Chuck, CABGx3
 
Thanks
It was most helpful.
Paul

CLR said:
Use "Conditional Formatting"

Click on the cell, do Format > ConditionalFormatting > CellValueIs > EqualTo


Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Back
Top