Hey everyone, I've been trying to figure out how to do this certian function for the last hour, with no real progress. I appologize if this is in the wrong section. What I'm trying to do is this:
I have created a drop down box that allows me to choose multiple different Text Options.
Example: Cell B4 has dropdown that lets me choose the Text Options, "House", "Car" and "Truck".
Next, I have 5 or so other columns underneath with their own text. What I want to do is have different cells highlight themselves depending on what is in Cell B4.
Example, if "House" is selected in B4, I want cells B7 and B9 to highlight. If "Car" is selected, I want cells B7, B8, and B10 to highlight. If "Truck" is highlighted, I want cells B9-B11 to highlight.
Is this possible to do? I've tried using If/Then statements, but those don't seem to work for this type of thing.
Any help would be greatly appreciated. Also, I am using Excel 2007.
Bookmarks