Conditional Formatting Based on Match to Separate List

[sunday_storyteller]

I have two worksheets with location names on them. Each location name is unique. The lists are generated for two different weeks. I would like to set conditional formatting so that if a Location on the 2nd sheet shows upon the 1st sheet, it is highlighted. (So I can flag which locations showed up twice in a row.)

Is this possible? To do a conditional formatting based on a list? That is, "if this location on Sheet2 is equal to a location on Sheet1, then highlight the location on Sheet2"

Thanks!

Calinda

 

[barry houdini]

Assuming both lists are in column A.

Select column A in sheet2

Format > Conditional Formatting > "formula is"

=MATCH(A1,INDIRECT("sheet1!A:A"),0)

select desired formatting, OK