shaneodwyer
New Member
- Joined
- Apr 22, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello, hoping someone can help on what i thought was an easy task!
I have a list of email address on tab1 column A. on tab 2 i have another list of email addresses, however these are across columns A-BZ
im trying to do conditional formatting to highlight in red anywhere in columns A-BZ where any of the value's from tab1 column A appear.
i tried the "format only cells that contain" formula and select all the values in tab1 column A but doesnt seem to formatting the correct values.
I am thinking the "Use a formula to determine which cell to format" option but i don't know what formula i could use.
I thought it was a straightforward formula, look up all the values in one tab against multiple columns in another and highlight the matches but appears not.
any help would be really appreciated.
I have a list of email address on tab1 column A. on tab 2 i have another list of email addresses, however these are across columns A-BZ
im trying to do conditional formatting to highlight in red anywhere in columns A-BZ where any of the value's from tab1 column A appear.
i tried the "format only cells that contain" formula and select all the values in tab1 column A but doesnt seem to formatting the correct values.
I am thinking the "Use a formula to determine which cell to format" option but i don't know what formula i could use.
I thought it was a straightforward formula, look up all the values in one tab against multiple columns in another and highlight the matches but appears not.
any help would be really appreciated.