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

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

Hi Barb,

This works very nicely.

Thankyou so much!

All the best,

Roger

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