View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
albertfirst albertfirst is offline
external usenet poster
 
Posts: 2
Default Conditional Formating

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