CF

  • Thread starter Thread starter ganga
  • Start date Start date
G

ganga

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.
 
Back
Top