Formatte issue

[S. A. Stone]

I need to be able to right a conditional Formatte that can highlight a cell
(group of cells) in a sheet based on the time of day ... For instance... if
the starting time (cell C4) is 02:29 and the ending time (cell D5) is 04:30
then any time with in this range the cell should be high lighted. Any other
time the cell is not.

Scott

 

[p45cal]

I need to be able to right a conditional Formatte that can highlight
cell
(group of cells) in a sheet based on the time of day ... Fo
instance... if
the starting time (cell C4) is 02:29 and the ending time (cell D5) i
04:30
then any time with in this range the cell should be high lighted. An
other
time the cell is not.

Scott

Which version of Excel?

For xl2003

Select the cell(s) you want conditionally formatted, choose 'Formul
is' and paste this formula:
=AND(MOD(NOW(),1)>=$C$4,MOD(NOW(),1)<=$D$5)

set your format and finish.
When the time comes to a flip-over, the sheet will need to b
recalculated for the formatting to change