Highlighting Current Week??

[jrusso]

Say these are my rows A< B< C < D < E
How do shade the current weeks row
Thanks


18-Mar... 24-Mar.... 3,565.00 .... 30.00 .... 1%
25-Mar... 31-Mar.... 3,535.00 .... (380.00).... -11%
1-Apr ... 7-Apr.... 4,771.52 .... 285.03 ..... 6%
8-Apr ... 14-Apr.... 4,440.47.... (521.19).... -12%
15-Apr.... 21-Apr.... 3,130.47 .... 648.62 ..... 21%

[FDibbins]

Highlight the range you want to apply the CF to, Select Conditional Formating, select "use formula" and then enter this...

=WEEKNUM($B1)=WEEKNUM(TODAY())

[jrusso]

Hey Dibs

It worked to a degree but highlights next week meaning starting tomorrow

Weeks are Monday to Sunday....East Coast USA..time zone

Thanks

[FDibbins]

I tested it by adding another week - 22 Apr:29 Apr - and it worked fine.

Try changing the CF formula to...
=WEEKNUM($B1,2)=WEEKNUM(TODAY(),2)

[Tony Valko]

Try it like this...

Let's assume the data is in the range A2:G6.

=$A2=TODAY()-WEEKDAY(NOW(),2)+1

[jrusso]

They both worked
Good job Dibs and Valco

If I want to do the same for current month what would it be

JAN 1-Jan-13 ... 31-Jan-13
FEB 1-Feb-13...... 28-Feb-13
MAR 1-Mar-13 ..... 31-Mar-13
APR 1-Apr-13 ...... 30-Apr-13

[Tony Valko]

Maybe this...

Month names in column A.

=$A2=TEXT(NOW(),"mmm")

[FDibbins]

or...
=MONTH($B1)=MONTH(TODAY())