Hi Sekhar,

Go to Format, conditional formating then you can give upto 3 conditions.

Arul

"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