change a cell colour when entering a letter

P

paul42770

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.
 
C

CLR

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
 
P

paul42770

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...
 

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

Change the colour of a neighbouring cell 6
Transfer data between two tables 3
Insert name and adress from a list in a word document 1
Is it possible to edit colours already saved as part of a custom theme? 0
Merging from an Excel file with graphics 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Excel does not accept text format! 0
Cell data entering slow! 0

Top