Conditional Formatting Help-What I want to do is compare them

Hi guys,

I'm a bit of a novice Excel user, and I'm trying to do something that I think is quite simple, and am finding it quite hard.

One of the columns (G) in my spreadsheet is a list of colleagues names... What I want to do is compare them to a smaller list of peoples names (that is on sheet 2) and if there are any matches, I want them to be shown in red across the entire row where that match occurred... Is this possible?

Thanks in advance.

OK,

lets assume you have data from row 1 to 100 and you want to make the entire row red (column A to column Z) within this range whenever name in column G matches any name in sheet2!A1:A50

Select

A1:Z100 with A1 "active cell"

Format > Conditional Formatting > "formula is" option

=MATCH($G1,INDIRECT("sheet2!A1:A50"),0)

Originally Posted by daddylonglegs

OK,

lets assume you have data from row 1 to 100 and you want to make the entire row red (column A to column Z) within this range whenever name in column G matches any name in sheet2!A1:A50

Select

A1:Z100 with A1 "active cell"

Format > Conditional Formatting > "formula is" option

=MATCH($G1,INDIRECT("sheet2!A1:A50"),0)

Thank you so much for your help!!

Just to progress from this idea, does anyone know how I can delete the rows where there is a match instead of just changing their formatting?

Anyone any ideas?

For that sort of thing you'd need VBA, not my forte....I suggest you start a new thread in Excel programming where you might get more help