Can Excel 2003 identify and highlight repeated cell entries in multiple sheet
workbook as you type? It does it automatically on a single sheet but can it
also work in a mutiple sheet workbook? Eg. if I type Smith in a cell on sheet
3 can this be highlighted if Smith was also typed in sheet 1?