I am trying to format my sheet so that it will highlight the cell only if my drop down menu changes from one value to another. I know how to make it highlight with a combination of VBA and conditional formatting, but that also makes it so if i even click into the menu, that it will highlight the cell. I want it to highlight ONLY if the cell changes. For example, here's my drop down list....
4. Issue Approval
If the value changes from "1. WIP" to "2. Queue", highlight the cell green. If the value stays the same, do nothing.