Hi,
Is there a way for a cell to be highlighted if the reference in the cell has been used before/repeated elsewhere within multiple sheets.
At the moment I have =COUNTIF(C:C,C20)>1 as a condtional format in each sheet, however it only looks up column C in the current sheet, what I wondering was if it was possible to have a formula that looks at column C for all the sheets in the workbook.
Thank you
Bookmarks