I have 3 drop down menu and based on that i want to highlight the cell.

eg: one of drop down menu called "tech". If I choose the name from that menu
in A1 and if i type "sick" in the B2 i want that (b2) to be highlighted blue.

and if i choose the name from other drop down i want that to be highlighted
green

Please help me with this and thank you in advance.

You probably want a conditional format something like this:
=and(a1="tech",b2="sick")

Regards,
Fred.

"ganga" <(E-Mail Removed)> wrote in message
news6BCF3A3-B0FB-4BD2-A7EA-(E-Mail Removed)...
>I have 3 drop down menu and based on that i want to highlight the cell.
>
> eg: one of drop down menu called "tech". If I choose the name from that
> menu
> in A1 and if i type "sick" in the B2 i want that (b2) to be highlighted
> blue.
>
> and if i choose the name from other drop down i want that to be
> highlighted
> green
>
> Please help me with this and thank you in advance.