Question...

[TyeJae]

Ok I have a list of dates spread across the top of my spreadsheet liste
for every Monday from now until the end of December. And every week
come into the document and highlight the week that it is currently i
green, and turn the last week's back to white. Is there a way to d
this automatically so that I do not have to manually do it every week?

Thanks,
Tyeja

 

[Frank Kabel]

Hi
try using a conditional format.e.g. if you data starts in A1 try:
- select your data in row 1
- goto the conditional format dialog and enter the following formula:
=(a1<TODAY()-WEEKDAY(TODAY(),3)+7)*(a1>=TODAY()-WEEKDAY(TODAY(),3))
- choose a format for the current week

 

[TyeJae]

Thanks Frank that worked great!

TyeJa