Is it possible to highlight entire rows based on the days?

**gloom52** · 09-08-2009, 06:58 PM

Is it possible for the excel to automatic highlight entire rows if the row has a day that falls on a saturday or sunday?

**JBeaucaire** · 09-08-2009, 07:06 PM

You can do this with conditional formatting. You'll need to post up a sample sheet if you want specific assistance with that.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

**gloom52** · 09-08-2009, 07:11 PM

here is the file. it might be a bit messy cuz im still new to these formulas

**Palmetto** · 09-08-2009, 07:32 PM

Use Conditional Formatting, Formula option and use this, adjusted for your actual range:

=OR(WEEKDAY($A4)=1,WEEKDAY($A4)=7)

See attached, sheet Aug09.

All fill color was removed and currently highlighted rows are due to conditional formatting using the above formula.

**gloom52** · 09-09-2009, 09:00 AM

wow amazing thanks alot. you helped me a great deal. I had so much trouble with this. Everytime I changed a formula I had to refill everything.

**Palmetto** · 09-09-2009, 09:03 AM

Glas to have helped.

If you're satisified with your solution please mark your thread as solved and be sure to add to each users reputation by clicking on the blue scales icon in a relevant user post in this thread.

**gloom52** · 09-09-2009, 09:21 AM

Under my "Team Schedule" sheet, actually the 4 teams will rotate around W,R,O,O,D,D,N,N every 8 days. Is there a way for the excel to auto generate this sequence with the date at the side auto updating as well??