customizing cell content

A

ai

would it be possible to customize a cell content?for e.g. if i type A ,itll
be color Blue . and if i type P it will be color Green.the entire worksheet
consist of 3-4 letters only ,1 letter per cell .would really be thankful if
someone could help me with this.thanks!
p.s. i can work on either 2003 or 2007 version
 
G

Gord Dibben

Format>Conditional Formatting.

Note Excel 2003 resticts you to 3 conditions.........4 if you count default.

2007 has many more.


Gord Dibben MS Excel MVP
 

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

customizing text color 2
"Custom Sort" Question 5
Unwanted color in cells of spreadsheet. How do I remove the color? 1
Excel 2007 Bug in Custom Theme Colors 0
For Joey2004 et al. From OP: Re Appending Question 3
Can't you edit the color palette in Excel 2007? 1
How to add cell's reference to cell's content 5
Formula to set cell color 3

Top