Hello
I use excel 2003 , and would like to know if there is any possibilities
to have more than 3 conditional formatting.
I use Vlookup to bring different information to the same cell from different
data sheets
and the results are different ,almost of the results.
I have 5 colors for those results (blue , red , green , light blue, violet)
The results are text ( 09 T , 88 I , 7 C 2 ...etc )
I would like to create one color for some results , and other color for
other results.
Is it possible by using the formula IF , and if so
Please can you let me know.
Thank you very much in advance.
Albert & Gin-Lian

Hi Albert
You may want to look at this site for your information.
Regards
Cimjet

http://www.xldynamic.com/source/xld.....Download.html

"albertfirst" wrote in message
...
Hello
I use excel 2003 , and would like to know if there is any possibilities
to have more than 3 conditional formatting.
I use Vlookup to bring different information to the same cell from
different
data sheets
and the results are different ,almost of the results.
I have 5 colors for those results (blue , red , green , light blue,
violet)
The results are text ( 09 T , 88 I , 7 C 2 ...etc )
I would like to create one color for some results , and other color for
other results.
Is it possible by using the formula IF , and if so
Please can you let me know.
Thank you very much in advance.
Albert & Gin-Lian