time cell Highlight

P

Pivotrend

how do i make a time cell that is behind Real time of less than
minutes be highlighted

i know how to use conditional formating but i dont know how to inpu
information in time

ie: A1= Real time 17:35

B1=17:33
B2=17:25
B3=17:18

in this case i need cell B1 to be highlighted which is behing Real tim
(A1) of less than 5 minutes............
 
F

Frank Kabel

Hi
use a formula in the conditional format such as
=(B1>=NOW()-TIME(0,5,0))*(B1<NOW())
 
Top