software

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 **

Hi

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

Andy.quot;Jaydubsquot; gt; wrote in message
...
gt; Dear Excellent users.
gt;
gt; I have a day [=TODAY()] in field AK1
gt; In A1 I have the number of the week.
gt; In fields A2 till E2 I have the five days of the week noted in MM-DD
gt;
gt; Now I want to use conditional format for the number of the week. I want to
gt; check if the day of AK1 falls in the range of A2 till E2. If such is the
gt; case, I want the number of the week highlighted.
gt;
gt; Can someone help me??
gt;
gt; Thank you !!
gt;
gt; --
gt; ** Fool on the hill **
Assuming the data in A2:E2 is dates fromatted as MM-DD then select A1 asn
use conditional formatting

Formula is =AND($A$2lt;=TODAY(),$E$2gt;=TODAY())

unless you need TODAY() in AK1 for something else, you can do away with it.

--
Ian
--
quot;Jaydubsquot; gt; wrote in message
...
gt; Dear Excellent users.
gt;
gt; I have a day [=TODAY()] in field AK1
gt; In A1 I have the number of the week.
gt; In fields A2 till E2 I have the five days of the week noted in MM-DD
gt;
gt; Now I want to use conditional format for the number of the week. I want to
gt; check if the day of AK1 falls in the range of A2 till E2. If such is the
gt; case, I want the number of the week highlighted.
gt;
gt; Can someone help me??
gt;
gt; Thank you !!
gt;
gt; --
gt; ** Fool on the hill **
Hello Ian,

Thank you very much for your answer. It works for me. I do need the AK1
field for other comparisons, so I will compare to AK1, instead of TODAY() in
the conditional format.
--
** Fool on the hill **quot;Ianquot; wrote:

gt; Assuming the data in A2:E2 is dates fromatted as MM-DD then select A1 asn
gt; use conditional formatting
gt;
gt; Formula is =AND($A$2lt;=TODAY(),$E$2gt;=TODAY())
gt;
gt; unless you need TODAY() in AK1 for something else, you can do away with it.
gt;
gt; --
gt; Ian
gt; --
gt; quot;Jaydubsquot; gt; wrote in message
gt; ...
gt; gt; Dear Excellent users.
gt; gt;
gt; gt; I have a day [=TODAY()] in field AK1
gt; gt; In A1 I have the number of the week.
gt; gt; In fields A2 till E2 I have the five days of the week noted in MM-DD
gt; gt;
gt; gt; Now I want to use conditional format for the number of the week. I want to
gt; gt; check if the day of AK1 falls in the range of A2 till E2. If such is the
gt; gt; case, I want the number of the week highlighted.
gt; gt;
gt; gt; Can someone help me??
gt; gt;
gt; gt; Thank you !!
gt; gt;
gt; gt; --
gt; gt; ** Fool on the hill **
gt;
gt;
gt;

Glad it works for you and thanks for the feedback.

--
Ian
--
quot;Jaydubsquot; gt; wrote in message
...
gt; Hello Ian,
gt;
gt; Thank you very much for your answer. It works for me. I do need the AK1
gt; field for other comparisons, so I will compare to AK1, instead of TODAY()
gt; in
gt; the conditional format.
gt; --
gt; ** Fool on the hill **
gt;
gt;
gt; quot;Ianquot; wrote:
gt;
gt;gt; Assuming the data in A2:E2 is dates fromatted as MM-DD then select A1 asn
gt;gt; use conditional formatting
gt;gt;
gt;gt; Formula is =AND($A$2lt;=TODAY(),$E$2gt;=TODAY())
gt;gt;
gt;gt; unless you need TODAY() in AK1 for something else, you can do away with
gt;gt; it.
gt;gt;
gt;gt; --
gt;gt; Ian
gt;gt; --
gt;gt; quot;Jaydubsquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Dear Excellent users.
gt;gt; gt;
gt;gt; gt; I have a day [=TODAY()] in field AK1
gt;gt; gt; In A1 I have the number of the week.
gt;gt; gt; In fields A2 till E2 I have the five days of the week noted in MM-DD
gt;gt; gt;
gt;gt; gt; Now I want to use conditional format for the number of the week. I want
gt;gt; gt; to
gt;gt; gt; check if the day of AK1 falls in the range of A2 till E2. If such is
gt;gt; gt; the
gt;gt; gt; case, I want the number of the week highlighted.
gt;gt; gt;
gt;gt; gt; Can someone help me??
gt;gt; gt;
gt;gt; gt; Thank you !!
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; ** Fool on the hill **
gt;gt;
gt;gt;
gt;gt;

Another way....

=MATCH(AK1,A2:E2,0)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=522998That's the good (and frustrating) thing about Excel. For any given problem
there is normally more than one solution.

--
Ian
--
quot;daddylonglegsquot; gt;
wrote in message
news:daddylonglegs.24rlom_1142516401.7263@excelfor um-nospam.com...
gt;
gt; Another way....
gt;
gt; =MATCH(AK1,A2:E2,0)
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=522998
gt;