View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve[_71_] Steve[_71_] is offline
external usenet poster
 
Posts: 47
Default Set cell background based on date.

sorry for the multiple postings. The first time i submitted it, i got an
error message.

Steve

"Steve" wrote:

I saw a post similar to this earlier this week. I However i was unbale to get
it to work. My question is: I am working a caladar for work. I want a certian
set of cells to be highlighted, color is unimportant, based on todays date.
So if I open the workbook today, Oct. 28th will be highlighted. Tomorrow Oct
29th will be highlighted.

Thanks for your help,
Steve