conditional formatting (1 Viewer)

[Antony Cole]

Hi,

I have created a form from a crosstab query which is a 52 week planeer. The weeks are displayed in the column titles Week1, 2 , 3 and so on. I need to highlight the current week of the year so that a user knows exactly what week he/she is working on. Anybody know thwe solution. without the dates i cannot seem to get the answer i want.

thanks

Antony

 

[billmeye]

You should be able to use Conditional Formatting testing each week for:

=Format(Date(),"ww")

The only problem you may encounter is sometimes there are '53' weeks in the year.