| 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 ** |
| 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) | |||
Threaded Mode
