text color???

S

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

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

kkknie

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