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