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.

Lastly, I have a similar post like this one on Mr. Excel. I want to reach a broader audience therefore I am hoping someone in this forum can help me with a VBA solution. Here is the link to the Mr. Excel Post:

http://www.mrexcel.com/forum/excel-q...ay-sunday.html

- BC