Weekend dates conditional format

  • Thread starter Thread starter Tonso
  • Start date Start date
T

Tonso

I have an XL2003 workbook that lists the dates of the month and the
day of the week. Example:

07/01/10 Thu
07/02/10 Fri
07/03/10 Sat
07/04/10 Sun
07/05/10 Mon

Both columns are formatted as dates, with the day column formatted
"ddd".
I would like to be able to conditionally format the dates so on that
weekend days, the day font will be formatted white, so it is
invisible.

Thanks

Tosno
 
I have an XL2003 workbook that lists the dates of the month and the
day of the week. Example:

07/01/10        Thu
07/02/10        Fri
07/03/10        Sat
07/04/10        Sun
07/05/10        Mon

Both columns are formatted as dates, with the day column formatted
"ddd".
I would like to be able to conditionally format the dates so on that
weekend days, the day font  will be formatted white, so it is
invisible.

Thanks

Tosno
Click to expand...

=weekday(a1)=1
=weekday(a1)=7
 
Another one:

=WEEKDAY(A1,2)>5

Where A1 is the active cell in your selected area.

ps. You could also use just a single column of cells and give it a custom
format of:

mm/dd/yyyy ddd
 
Back
Top