change cell color

P

Philip

I have made a drop down box, but now want to make when I select a specific
word it will change back ground color in whole row. Say I pick UT for Utah in
my drop down box I want the row to change background color to green, if I
select ID the row changes to purple. Is this possible?
 

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

Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Dynamic Naming of Form Button 3
Need help modifying code 0
Paragraph numbering in Word 1
active combobox - possible to configure as display value andcoordinate value? 3
Change the colour of a neighbouring cell 6
Excel does not accept text format! 0

Top