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. |
#2
|
|||
|
|||
Let's say the data to be checked is being entered in column D:
20051001 5:55 17:47 18:00 20051002 5:56 17:46 11:00 Click on D1 (the 18:00) and pull-down Format Conditional Formating... and then add two separate conditions. If D1 is less that B1, color the cell. If D1 is greater than C1, color the cell. Experiment by changing the value in D1 until you are satisfied with the appearance. Then copy the format down the column. Have a good day -- Gary's Student "armyaviatr" wrote: 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. |
#3
|
|||
|
|||
When the time is entered, how should XL know which date it applies to?
In article , "armyaviatr" wrote: 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. |
Reply |
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 |