customizing text color
 

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

customizing text color
 

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

customizing text color
 

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


Gord Dibben MS Excel MVP

On Thu, 14 Aug 2008 11:25:01 -0700, 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.?