Hi

With A1 selected, go to Format/Conditional Formatting use Formula Is and
then:
=COUNTIF($A$2:$E$2,AK1)0

Andy.


"Jaydubs" wrote in message
...
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 **