Locate Saturday and Sunday

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

You can use conditional formatting for this - no need for any VBA code. With cell from L2 down selected, click on Conditional Formatting | New Rule | Use a Formula ..., and then enter this formula in the dialogue box:

=WEEKDAY(L2,2)>5

Then click the Format button | Fill tab and choose yellow, then OK your way out.

Hope this helps.

Pete

Pete_UK,

thank you for your response first of all. The solution that I am going for will require a an Add-in. I say this because an individual will not be using the same workbook. I want to give the user the ability to use any workbook they want and then import the data that contains dates.

The idea is that the users can then click on the add-in and it will do what I described in my post.

- BC