Excel 2003 - Highlighting weekends in colour

  CHarker 09:27 17 Apr 2008


I've got colum A2 to A251 showing dates from April 26th to 31st December 2008. I'd like the weekend dates to be highlighted in a colour.

Any idea how this can be done?

  johnnyrocker 09:37 17 Apr 2008

'if' formula stating days ( ie sat/sun ) and choose a colour?


  Picklefactory 10:47 17 Apr 2008

I can only manage it so far, by adding another column.
In adjacent column (I used column B) add formula =WEEKDAY(A2) (For 1st cell), this will show the day code (1-7). eg A2=1/4/08 and B2=3, drag this down the column.
Select cell A2 and in conditional formatting, format cell based on formula =$B2=7 and format as you please, create a 2nd formula based format where =$B2=1 and format the same. Copy this format to the remaining cells in column A and that should work.
I'm fairly confident someone else might find an easier way. Possibly VBA would be better, but beyond me I think.

  johnnyrocker 10:53 17 Apr 2008

what about the find/replace feature?


  Picklefactory 10:53 17 Apr 2008

Just select entire row A and in conditional formatting based on fromula, enter =(WEEKDAY($A1,2)>5)*($A1<>"") and format as required.

  Picklefactory 10:54 17 Apr 2008


  Picklefactory 11:07 17 Apr 2008

Select only cells that require formatting and in conditional format formula box enter
and format accordingly.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?