Hi,

Select the entire row and apply the folowing conditional format formula

=AND(WEEKNUM(A1)=WEEKNUM(NOW()),YEAR(A1)=YEAR(NOW( )))

Mike

"Carolina Girl" wrote:

Help!!! I think this can be done but Im not sure how to do it€¦ I need to
highlight an entire row basted on a date in the first column. I will
explain€¦. Column A has dates starting with 7/6/09 I have information in
columns €œB-AE€� if the date in €œA€� falls into this week (changing each week)
A-AE will highlight in orange€¦ Can this be done as a conditional format or a
VBA? Any help would be great€¦.