change cell color
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?