Conditional formatting based on todays date

[Jimmy_L]

Hi!
I have a deployment chart with the week start date in the top row and week end date in the row beneath it.
In the rows beneath this I have products lists and a count of their deployments relating to the week dates above.
I am trying to automate the sheet so that the column relating to the current week is highlighted.
Any suggestions would be greatly appretiated.
Many thanks in advance.

 

[Lewiy]

Highlight the whole sheet and enter the conditional format formula:

=AND(A$1<=TODAY(),A$2>=TODAY())

 

[Richard Schollar]

Another alternative:

Excel Workbook
	B	C	D	E	F	G
1	23/07/2007	30/07/2007	06/08/2007	13/08/2007	20/08/2007	27/08/2007
2	27/07/2007	03/08/2007	10/08/2007	17/08/2007	24/08/2007	31/08/2007
3	Blah	Blah	Blah	Blah	Blah	Blah
4	Blah	Blah	Blah	Blah	Blah	Blah
5	Blah	Blah	Blah	Blah	Blah	Blah
6	Blah	Blah	Blah	Blah	Blah	Blah
7	Blah	Blah	Blah	Blah	Blah	Blah
8	Blah	Blah	Blah	Blah	Blah	Blah
9	Blah	Blah	Blah	Blah	Blah	Blah
10	Blah	Blah	Blah	Blah	Blah	Blah
11	Blah	Blah	Blah	Blah	Blah	Blah
12	Blah	Blah	Blah	Blah	Blah	Blah
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	1. / Formula is =LOOKUP(TODAY(),$B$1:$G$1)=B$1	Abc

 

[Jimmy_L]

Brilliant!
Thanks a lot guys!!