Weekend dates conditional format

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
 
D

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top