View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger on Excel Roger on Excel is offline
external usenet poster
 
Posts: 249
Default 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