When the time is entered, how should XL know which date it applies to?


In article <C9479E7D-F7F0-4D9F-B0C6-C528C7F18F33@microsoft.com>,
"armyaviatr" <armyaviatr@discussions.microsoft.com> 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.