customizing text color

[ai]

would it be possible to assign color for a certain letter in a cell
content?e.g all the content of the cell in my worksheet consist of either of
these 4 letters only ( A , P , N , O).can it be that if i type A it would be
in color Blue,and if i type P it would be Green,etc.?

 

[Gary''s Student]

Yes. You can use Conditional Formatting. See:

http://www.contextures.com/xlCondFormat01.html

 

[Gord Dibben]

Same answer you got to your post with a different subject line.


Gord Dibben MS Excel MVP