| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ** |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking if a certain day falls in a range
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 ** |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking if a certain day falls in a range
Assuming the data in A2:E2 is dates fromatted as MM-DD then select A1 asn
use conditional formatting Formula is =AND($A$2<=TODAY(),$E$2=TODAY()) unless you need TODAY() in AK1 for something else, you can do away with it. -- Ian -- "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 ** |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking if a certain day falls in a range
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 ** "Ian" wrote: Assuming the data in A2:E2 is dates fromatted as MM-DD then select A1 asn use conditional formatting Formula is =AND($A$2<=TODAY(),$E$2=TODAY()) unless you need TODAY() in AK1 for something else, you can do away with it. -- Ian -- "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 ** |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking if a certain day falls in a range
Glad it works for you and thanks for the feedback.
-- Ian -- "Jaydubs" wrote in message ... 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 ** "Ian" wrote: Assuming the data in A2:E2 is dates fromatted as MM-DD then select A1 asn use conditional formatting Formula is =AND($A$2<=TODAY(),$E$2=TODAY()) unless you need TODAY() in AK1 for something else, you can do away with it. -- Ian -- "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 ** |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking if a certain day falls in a range
Another way.... =MATCH(AK1,A2:E2,0) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=522998 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking if a certain day falls in a range
That's the good (and frustrating) thing about Excel. For any given problem
there is normally more than one solution. -- Ian -- "daddylonglegs" wrote in message news:daddylonglegs.24rlom_1142516401.7263@excelfor um-nospam.com... Another way.... =MATCH(AK1,A2:E2,0) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=522998 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA at Source range (in Data-validation-List) gives wrong re | Excel Worksheet Functions | |||
| update cell only if now() falls in a given date range | Excel Worksheet Functions | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| Checking ALL values in a range | Excel Discussion (Misc queries) | |||
Linear Mode
