Highlighting Cells using VBA (?)

[Dynamo418]

Hi guys,

I need a VBA macro (activated using a clickable button) that will highlight a cell in a column if it is for the right date. So, a user will enter 08/07/2012 in cell A1, the macro will search for that date from a list of dates in column B, and will highlight the perpendicular cell value in column C. Can anyone help out? Sort of like a Vlookup + conditional formatting.

Thanks!

[royUK]

Why not just use Conditional Formatting?

[Dynamo418]

That would work fine, I've never done conditional formatting w/a vlookup, can you explain further?

[ChemistB]

Select your range (i.e. B2:B5000)
Conditional Formatting>New Rule> Use Formula
=AND($B2=$A$1, ISNUMBER($B2))
Does that work for you? I added the ISNUMBER part in case A1 is blank, it doesn't highlight all your blank cells

---------- Post added at 11:32 AM ---------- Previous post was at 11:30 AM ----------

Oops, didn't see the part about Col C is what you want highlighted. You say Perpendicular. I assume you want the cell in the same row as the date in B.

As above, except initially select the range in Col C, not B

[Dynamo418]

The issue is that I'm not matching the value in A1 with the values in column B. I'm matching the value in A1 (a date) with the values in column C, and then highlighting the perpendicular cell in column B. So, if A1 is 08/08/2012, and C5 is 08/08/2012, then B5 will be highlighted. Does that make sense?

[ChemistB]

Okay, I got it backwards (or sideways)
Select range in Column B (i.e. B2:B2000)
Conditional Formatting>New Rule> Use Formula
=AND($C2=$A$1, ISNUMBER($C2))
That will do what you are asking for.

[Dynamo418]

Worked like a charm! Thanks!!!