Formating date ranges for weekends
 

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

Formating date ranges for weekends
 

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

=AND(WEEKDAY(A2,2)=6,ISBLANK(A2)=FALSE)
--
HTH,
Barb Reinhardt



"Roger on Excel" wrote:

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

Formating date ranges for weekends
 

Hi Barb,

This works very nicely.

Thankyou so much!

All the best,

Roger

Formating date ranges for weekends
 

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


"Barb Reinhardt" wrote:

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

=AND(WEEKDAY(A2,2)=6,ISBLANK(A2)=FALSE)
--
HTH,
Barb Reinhardt



"Roger on Excel" wrote:

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