I'm trying to create a macro that will highlight data in a given range when another cell is selected. For example, the value of cell F4 is "AG". If I select that cell, I want all of the cells in the range D2:D15 to be highlighted when the corresponding cells in the range C2:C15 equals "AG".
[attachment][/attachment]