I have a project at work, that will involve many people updating the same workbook in excel.
In Column A of every sheet, the cells are a text text field NNNXXXX. I want when I enter data in a cell in column A to highlight if that data is already entered in another sheet in workbook, in Column A.
I see how to highlight if it's on the same sheet, under conditional formatting, but was looking for it to search all sheets in workbook and highlight cell if data entered is a duplicate.
thanks