I am trying to set up a "track changes" method using conditional formatting rule while using the Data Validation menu list. Currently the text in the cell is pre-populated. If the user changes the text via the drop down menu list, I want the cell to change text color/highlight so I know it was changed. I don't know how to get that rule set up. Any suggestions greatly appreciated
Bookmarks