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.

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.

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.