Change the row background color by weekend dates

**kammariarun** · 11-14-2011, 08:40 PM

Hi,

I am trying to format the rows in my sheet based on weekend dates. I tried to use conditional format but was unsuccessful. I have attached my work sheet. Column C has a calendar object.
I have used =INDIRECT("C"&Row())= Weekday($C5,2)>5) but not doing any think. Any help is greatly appreciated.

Thanks

**MarvinP** · 11-14-2011, 08:52 PM

Hi kammariarun,

try this in a conditional formatting formula

Please Login or Register  to view this content.

See attached

**daddylonglegs** · 11-14-2011, 08:54 PM

In the attachment the conditional formatting appears to be working fine with the formula

=WEEKDAY($C5,2)>5

which is pretty much what I would have suggested - I don't see the problem

**optomyst** · 11-14-2011, 09:20 PM

Just change your conditional format range to $C$5:$X$214

**kammariarun** · 11-15-2011, 09:49 AM

Originally Posted by optomyst

Just change your conditional format range to $C$5:$X$214

Thank you all. It worked when I chnaged the range. Did not realize that conditional format function automatically updates entire row.

Have a great day...