Formatte issue
 

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

Formatte issue
 

S. A. Stone;537071 Wrote:
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
Which version of Excel?

For xl2003

Select the cell(s) you want conditionally formatted, choose 'Formula
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 be
recalculated for the formatting to change.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147618