Conditional Formatting Help

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a report that lists each day starting at the
current date. I use Date() for the first column, Date()+1
for the second, and so on. This goes until Date()+20 at
the end, so it gives me three weeks. Since I dont see a
way to filter out the saturdays and sundays (If there is,
it would be alot better), Is there a way to use
conditional formation or something else to highlight the
Saturdays and Sundays. Thanks for your help.
 
You could use the weekday() function.
For instance on Nov 3rd 03
Weekday(Now()) returns 2, Sunday is 1 through Saturday is
7.
Hope this helps.
Fons
 
Back
Top