Find Saturday and Sunday

[boldcode]

Hello,

I have a spreadsheet that contains date values in cells found within Columns L and M. The first row is reserved for row titles so the dates values actually begin in row 2. I want to create a macro that can highlight cells (fill the cell with color yellow) if the date value is a Saturday or Sunday.

The number of rows change from time to time so I would need a solution that can account for this (something along the lines of L2 to last row in Column M).

Please let me know if something is not clear and thank you very much for your time and attention.

- BC

 

[Special-K99]

Cant you just use conditional formatting?

Select L2

Conditional Formatting
New Rule
Use a formula to determine...

=(OR(WEEKDAY(L2)=1,WEEKDAY(L2)=7))

Format as required
Use Format painter (paintbrush icon) to copy to other cells

 

[boldcode]

I looked into this and you can make it work that way, but I'm really looking for vba code that can do this. Thanks for your response Special-K99, appreciate it.

- BC