I think part of the confusion is coming from the way I have it set up, that is my fault. I am making this to be put into use July 1, as such I used a singles months printout and pasted it into all 12 months worth of worksheets. This is producing the same data in each month of the lead sheet. In actuality all months should have zeros or differnt numbers on the leadsheet due to each month inherintly having different productivity levels.

I am trying to get the Month1! sheet to highlight all of the numbers that do not appear on the Leadsheet which should be all numbers not in the Coumn marked actual YTD as well as any numbers in Actual YTD that do not shot up on Leadsheet, either due to the account number missing of through my own faulty formula.

Does that make any more sense?