text color???

[shpon]

Hi,
is it possible to formate cells or write a formula or macro
where for example, you have a cell and you put in different
texts in that cell and if you want the cell to show the
text blue if you have letter v in it and show it in color
red if you have letter s in the cell and so on and so on...
Thanks in advance.

 

[Peo Sjoblom]

You can use conditional formatting
for simplicity assume it is cell A1
do format>conditional formatting, formula is

=ISNUMBER(SEARCH("s",A1))

click format button, select a red font colour,
click add and repeat but use "v" instead and a blue font.
You can do this for 3 different conditions. Otherwise you have to
use an event macro but that can be turned off by a user..

 

[kkknie]

I've not used a whole lot of it, but look under conditional formatting.
That should do the trick.

 

[Frank Kabel]

Hi
have a look at 'Format - conditional Format'
See
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm
for more information

Though this will allow only three conditions. For everything else
you'll need VBA