For example, if I have a list in A1 with 4 options in a dropdown and option 1 is selected from that list, I want C1, E1, and G1 highlighted. If option 2 is selected, then I want B1, D1 and H1 highlighted. The cells would be empty other than the list in A1. Is there a way to tell which cells to highlight if a certain option is selected?
Bookmarks