Loop a column on Sheet1 and loop a row on Sheet2 to find a match

**johnnywinter** · 02-12-2009, 09:04 PM

This is over my head, any help will be appreciated. I looked at 50 posts on loops and am still confused.

Can I use a Loop to do this or is there a better way? Seems like I am trying to do 2 loops at the same time? Has to be done by VBA code.

If a value in Sheet("A") D12:D45 equals a value in Sheet("B") G12:BA12),

then highlight cells in rows 10 to 45 in the column in Sheet("B") where the value matches.

The values in Sheet("A") are dates (no duplicates) as are the values in Sheet("B").

Thanks

**shg** · 02-12-2009, 09:15 PM

Why VBA? Why not just conditional formatting?

**johnnywinter** · 02-12-2009, 09:18 PM

The cells have conditional formatting for color already.

When I manual use Fill for color, the condtionally formated cells retain their color, which is what I want. (will VBA have the same effect?)

SHG, am I misunderstanding the use of conditional formatting?

**carddards** · 02-13-2009, 04:35 AM

Do you want to highlight in both sheets? Or just one sheet?

**royUK** · 02-13-2009, 04:44 AM

If you colour a cell using VBA you will be able to change that colour manually.

**johnnywinter** · 02-13-2009, 02:09 PM

carddards, just one sheet- I changed the post to be more explanatory.

If a value in Sheet("A") D12:D45 equals a value in Sheet("B") G12:BA12),

then highlight cells in rows 10 to 45 in the column in Sheet("B") where the value matches.