| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
time lookup
I am trying to do a conditional formating where the time entered into a cell
is checked against a list with sun rise and sun set values for a specific area. Date Sun Rise Sun set 20051001 5:55 17:47 20051002 5:56 17:46 The end result would be if the time is outside of Sun rise and Sun set the cell would change color, but still allow the time to be entered. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| help with date and time | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
Threaded Mode
