Formating date ranges for weekends

[Roger on Excel]

I have a row of dates which start from =TODAY() and increment by 1 along the
row giving a sequential row of dates.

The dates are all highlighted in one color

I would like to highlight weekends in a different color format to make them
stand out. I would like this to be done automatically.

Is there anyway to do this?

Thanks,

Roger

 

[Barb Reinhardt]

You can do this with a conditional format. Use this formula

=AND(WEEKDAY(A2,2)>=6,ISBLANK(A2)=FALSE)

 

[Roger on Excel]

Hi Barb,

This works very nicely.

Thankyou so much!

All the best,

Roger

 

[Roger on Excel]

Barb,

I have another question

I have an Excel Gantt chart. I would like to add a line down the rows to
coincide with each month end, so that each month range has verticla
boundaries.

The date range is along row 27.

I use the conditional formating you suggested to recognise weekends so I
suspect I can also use conditional formatting to recognise month ends.

What do you think?

Thanks,

Roger