Hi, I am still not able to see how the cells clear the fill in color once you have fixed the issue. They still stay either Red or Violet. The Duples are checked by the Columns that the data is keyed into. The missing required information is based off the the initial entry of the Client Name and should change to no color as we progress through the sheet. I would like it not to be triggered only when you enter the worksheet for the first time but instantaneously anytime you are on that sheet and working. If there is an easier way to have the legend popup I am game for that as well. I am also looking into how I can have it show again by a short cut key but that is later... I don't want to have to exit and enter the sheet each time to have it do validation checks and or run anything. Does that make sense?

Sample 11 the changing of Colors worked with the exception of the Dupe check it would clear the color of the one you fixed but leave the other one as still showing as a dupe.

Sample 12 none of the colors change..

Quote Originally Posted by Paul_Hossler View Post
I'm guessing that you'll prefer ver 12, even though it's a little slower