Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatte date in a1 calculate the date in A2 | Excel Worksheet Functions | |||
EXCEL - unable to get "TEXT" to wrap, even though cell is formatte | Excel Worksheet Functions | |||
How do I delete a line at the edge of a column that's not formatte | Excel Discussion (Misc queries) | |||
VBE Issue | Excel Programming | |||
VBE Issue | Excel Programming |