View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carolina Girl Carolina Girl is offline
external usenet poster
 
Posts: 25
Default Format row using date

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€¦.