Change cell color if it´s a weekend day

[abermann]

Hi there,
I´m developing an Excel sheet. After the user input a date in B6, all cells down to B90 are filled automatically with the right date.

What I need now is to change the row background color as long as that row belongs to a "B" cell that is a holiday (Saturday or Sunday), and I need to do it through VBA because this excel file will be handled by non technical people, so the whole process must be very easy to accomplish (I know how to perform this through CF using weekday, but that won´t do it for the reason I just wrote... it must be easier than that).

Thanks in advance!

 

[Norie]

You could set the conditional formatting using VBA.

Mind you I can't see why you couldn't apply the CF to the range manually.

 

[abermann]

Thanks for your answer, Norie,

I wonder the same, but they told me that users of this excel sheet may not being able to figure out how to apply a CF to the data, so... I have no option, but to make the process as transparent for the user as I can. The problem is I have almost no experience with VBA.

 

[MARK858]

users of this excel sheet may not being able to figure out how to apply a CF

They don't need to do anything to apply the CF, you do that. Apply your conditional formatting to B6 then use the format painter on the range up to B90. Job done. They don't touch the CF after that.

 

[abermann]

Mark858, thank you, that worked perfectly!

 

[MARK858]

Thanks for your feedback