How to do this in Excel?
I have a list of certain company names in column G (Sheet 1)
And I have a list of all company names in column A (Sheet 2)
Which conditional formatting formula can I use to highlight cells in Sheet 1 if they match any names from Sheet 2?
I have a list of certain company names in column G (Sheet 1)
And I have a list of all company names in column A (Sheet 2)
Which conditional formatting formula can I use to highlight cells in Sheet 1 if they match any names from Sheet 2?