Weekend dates conditional format

[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

 

[Don Guillett Excel MVP]

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

=weekday(a1)=1
=weekday(a1)=7

 

[Dave Peterson]

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

 

[Tonso]

=weekday(a1)=1
=weekday(a1)=7- Hide quoted text -

- Show quoted text -

Don,

works perfectly! thank you so very much!!

tonso