Hello,
I received some great help as to how to use code to color and entire row that has weekend dates. That code is below:
Sub foo()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
With ws.UsedRange.FormatConditions.Add( _
Type:=xlExpression, _
Formula1:="=WEEKDAY($A1,16)<3")
.Interior.Color = 12040422 'change to suit
End With
Next ws
End Sub
My next question - I was wondering if there is code for plugging in dates so an entire row get colored? These dates would be for holidays. Since some holidays change year-by-year (Veteran's Day, Labor Day, etc), I thought it would be easier to plug in the dates of these holidays. Instead of going to each month and manually highlighting the row.
Any help would be appreciated.
Thank you
Bookmarks