Formatte issue

  • Thread starter Thread starter S. A. Stone
  • Start date Start date
S

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
 
select the first cell
format(menu)-conditional format
choose "cells value is"
in the second window choose"between"
in the third window click the reference icon on the right and choose C4
in the fourth window click the reference icon on the right and choose D4
click the format in the second line right and choose pattern tab and choose any color.
click ok click ok
now copy the first cell down and click edit-pastespecial -format(only).
 
Last edited:
Back
Top