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

Tagged with

#rows.com
#Excel compatibility
#google sheets
#Excel alternatives for data analysis
#no-code spreadsheet solutions
#Excel alternatives
#Workbook
#Duplicate
#Sheets
#Highlight
#Column
#Code
#Number
#Excel
#Red
#Data
#Help
#Explanation
#A1546
#Cell