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" wrote in message
...
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.