You'll find a number of answers in the archives of this group.

http://www.xldynamic.com/source/xld.....Download.html is one example.
--
David Biddulph

"Argy - Arcasoft" wrote in message
...
David;
Very good point. Would you mind sharing how do you improve the number of
conditionals using VB under Excel 2003? Thanks.

Argy!


"David Biddulph" wrote:

Yes, in Excel 2007.
Otherwise, it needs a VBA solution.
--
David Biddulph

"Sekhar" wrote in message
...
Thank you Argy & Arul.

Conditional format was useful, but as you said limited to 3.
Is it possible t have more than 3, like say 12.

Thanks
Sekhar

"Argy - Arcasoft" wrote:

Hi Sekhar;
It is possible but limmited to three colors by cell. Excell 2007, in
theory,
makes this unlimmited because they saw the need for that option as it
has
been getting popular. Your choice is to use what is called
"Conditional
Format" under the Format menu. Let me know how it goes.

Argy


"Sekhar" wrote:

Hi

I have data which is segregated into 5 trypes A,B,C,D & E. If 'A'
appears in
cell A1, is there a way to color A1 in green,'B' in A1 then in
'yellow'
etc.

In short I am asking whether we have something like 'color if'
function. I
am using Office 2003.

Thanks in advance.
Regds

Sekhar