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!