Hi guys what i need is a bit of vba code that can change a range of cells backcolor if an adjacent cell contains a date.

i.e cells A1 to A55 and B1 to B55, if say B1 contains a date A1 turns GREEN, and if B15 contains a date A15 turns GREEN, but for the code to check all cells in B and change the A adjacent cell in A if the B column cell contains a date, i have tried conditional formatting, but would prefer using vba.

hope this is clear

scouse13