Excel 2007 search across multiple workshets in one workbook for all duplicates (macro or VBA code?)
Hello All: I need assistance in setting up a conditional format (worksheet within the workbook) to conditionally format for duplicates looking at 15+ worksheets. Just need to color both cells, not remove or otherwise change - just show the duplicate(s), if any. I suspect that it is a simple solution, but my knowledge of VBA is limited. If a macro would do, then that is great. I just need the simplest answer (as the user is not as savvy with Excel 2007). Any and all help (directions, code, etc) would be most appreciated. Thanks to everyone! Scott