| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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.? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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.? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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.? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
| Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
| Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Linear Mode
