ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional Formating (https://www.excelbanter.com/excel-programming/407158-conditional-formating.html)

albertfirst

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

Cimjet[_2_]

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