conditional formatting -help needed :)

[shaneodwyer]

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.

 

[steve the fish]

Something like:

=AND(A1<>"",ISNUMBER(MATCH(A1,Sheet1!A:A,0)))

 

[shaneodwyer]

hello, thanks for replying. sorry to be stupid but would this formula look up all the email addresses on tab 1 and check against multiple columsn on tab 2?

 

[steve the fish]

This particular one will look at whatever is in A1 and check if it is in column A of sheet1.