CF

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.
 
F

Fred Smith

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

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down choice needs to lead to another drop down menu 1
conditional formating for the whole row, based on one cell value 2
formula for if and v look up for 2 values 3
Linking choices in drop down menu to have automatic answer... 3
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Drop down menu display based on the value of different cell 2
INDIRECT Formula 3
Creating drop downs in a cell contingent on another drop down 1

Top