Format row using date
Mike
Thanks for the fast response. But my understanding is that WEEKNUM will not
work in 2003. Do you happen to have another suggestion??? I should also
mention that my list of dates are weeks ie 7/6, 7/13,7/20€¦. If today is 7/15
I need Cells A-E highlighted under for week of 7/13. Do you have any other
suggestions? Thanks again
"Mike H" wrote:
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€¦.
|