1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Highlight Column if Duplicate text in workbook

Hi All,

I have a Workbook that has probably 100+ sheets, I need to be able to highlight in Red column G if there is a duplicate number (example: A1546) in any of the other sheet within the workbook in their column G.

Is this possible please, I would appreciate anyone's help, I do need a full explanation of how to enter any code into my workbook as well please.

Many thanks in advance.
Shazz

submitted by /u/Shazzslat
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article