Hello all,
I'm still very new to the advanced functions of Excel and have spent hours on Google trying to find a formula/rule/macro that I can adapt, but have been unsuccessful, so i'm not sure if what I need is even possible...
Simply put: I'm trying to conditionally format (or similar) across multiple sheets in the same workbook.
I have attached a sample workbook to illustrate.
The "Archive" sheet will be just that, accumulating data daily.
The "Paste" sheet will be completely cleared and have a new set of data put in each day (always the same columns/rows/formatting).
I am trying to get excel 2010 to check all of column B ( so =$B:$B) in the "Paste" sheet, automatically when I paste data, against all of column B in the "Archive" sheet (which will progressively get larger). If a duplicate is found, highlight (or some indication) the cell on the "Paste" sheet only.
Thank you all in advance for any feedback. I'm sure there are others that would be interested in a solution as well.
Bookmarks