VBA - conditional formatting row based on cell value

[muss1210]

Hello forum

I am struggling to create VBA code that will conditionally format a row based on there being a date in column A, if blank ignore.My data range is dynamic so it could be 100 rows 1 day and 500 the next.
I would like columns A:L to be formatted grey if there is a date in column A

thanks for the help in advance

[Bernie Deitrick]

You can modify the index to get the specific shade of grey that you want...

Please Login or Register  to view this content.

[muss1210]

Thanks for the reply Bernie

When i ran the code nothing seemed to have happened, i added Sheets("Bulk").Select to make sure it ran on the correct sheet

[Pepe Le Mokko]

Do you really need a macro for this?

[Bernie Deitrick]

It works for me - see the attached. The only complication was fractions that could be interpreted as dates, so I changed that part.

If you still have problems, share a file with some of the values that you have in column A.