View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jaydubs
 
Posts: n/a
Default Checking if a certain day falls in a range

Dear Excellent users.

I have a day [=TODAY()] in field AK1
In A1 I have the number of the week.
In fields A2 till E2 I have the five days of the week noted in MM-DD

Now I want to use conditional format for the number of the week. I want to
check if the day of AK1 falls in the range of A2 till E2. If such is the
case, I want the number of the week highlighted.

Can someone help me??

Thank you !!

--
** Fool on the hill **