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 |
Conditional Formating
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 |
All times are GMT +1. The time now is 07:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com