vba to change cell color based on date

[scouse13]

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

[nankw83]

Hi scouse13 ... Something like this ?

Please Login or Register  to view this content.

[vba_php]

what about this?

Please Login or Register  to view this content.

https://docs.microsoft.com/en-us/off...range.interior

[scouse13]

sorry mate got confused, i am copying data to a sheet, so the dates will be in the copied cells, ie sheet2(sheet were data is copied to) range A1-A50, the code needs to check these cells and change green if they contain a date, sorry for the confusion

[nankw83]

Ok, how about now ?

Please Login or Register  to view this content.

[scouse13]

thanks for that, it works fine and i figured out how to change the font color as well, 1 more question if i may, i need to the code to check different columns, but not in order it needs to check column B and F nd i AND P, IS THIS POSSIBLE, CHANGING FONT COLOR AS WELL

[nankw83]

Hi scouse13,

Try the below code ...

Please Login or Register  to view this content.