conditional formatting for multiple values

[aravindhan_31]

hi,

can anyone tell me how do i write code for multiple conditional formatting,

for ex: if Cell A1 = Peronal Details then cell color shud be light blue,
if A1= Branch Details then cell color shud be light blue
and so on
I have a list of 17 items, if that items are entered in cel A1 the backround shud be light blue...

can anyone help me...

 

[Wajahat]

Re: need help for another macro

I Have 3 Values (A,P,L) in A1 which I Have to select from drop down list, If I select "A", cell color needs to change to Red, "P" green and "L" Yellow, Pls suggest how to do conditional formatting