Using Excel 2010.
使用Excel 2010。
I have a worksheet with 4 columns in it. I have Conditional Formatting (Highlight if duplicate) on the first 2 columns. The columns can have either text or numbers in the cells. The formatting works, as any cell in column A that is duplicated elsewhere, both the first one, as well as any additional ones are highlighted. Column B is the same way. I have a w