Help creating VB for highlighting entire row based on cell data

Hello - hoping someone can help.

I understand that Conditional Formatting can be used to highlight an entire row based on cell criteria. However, I have tried to create one rule to work for my entire workbook, but I can only get it to work for one worksheet. So I was wondering if there was a vb script for doing this.

What I have is a workbook with 12 worksheets (January thru December). In each worksheet there is listed the days of the week in each row. The columns headers are Date and Day.

So you would have:
Date Day
1/1/16 Monday
1/2/16 Tuesday

I want all rows that have Saturday and Sunday, highlighted in red.

I'm sure this is easy to do, but I just can't figure a vb script to do this.

Any help would be appreciated.

That worked perfect!! Thank you so much!!

Olly,

Along the line of the code you just gave me - is there code that will allow me to color an entire row if I plug in certain dates for holidays like Christmas, New Year's Day, etc.

Since some holidays change year-by-year (Veteran's Day, Labor Day, etc), instead of going to that day in the spreadsheet and coloring the entire row, I wondered if there was code that I could plug in the dates and the entire row would change color?

Any help would be appreciated.

Put your holidays in any column as you wish and name them Holidays and then Use this code to mark them with conditional formatting

Sub foo1()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
With ws.Cells.FormatConditions.Add( _
Type:=xlExpression, _
Formula1:="=COUNTIF(Holidays,$A1)=1")
.Interior.Color = 12040422 'change to suit
End With
Next ws
End Sub

Regards,
Mandeep baluja

So I'm just a bit confused with your code. I apologize. So if I want to add "12/25/2018" and "1/1/2019" to the code, where do I put it?? I have like 13 holiday dates to add. Again, I'm sorry to ask - I'm just that code savvy.

So in other words - in my workbook, create a worksheet called HolidayList and list all the holidays (say from A1 thru A13), then what part of this line would I change:

Formula1:="=COUNTIF(HolidayList,$A1)>0")

So would i change the code to:
Formula1:="=COUNTIF(HolidayList,$A1:$A13)>0")

Again - I apologize. I'm trying different things but it's not working right.

Boss you don't have to create a worksheet You can Enter your holidays in any sheet for example Sheet1!A1:A13 and then define a name for it by going to Ctrl+f3
and use that above code formula would be Formula1:="=COUNTIF(HolidayList,$A1)>0") or Formula1:="=COUNTIF(HolidayList,$A1)=1") and Run the code