Yes. You can use Conditional Formatting. See:
http://www.contextures.com/xlCondFormat01.html
--
Gary''s Student - gsnu200800
"ai" wrote:
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.?