Forum Discussion
M.Yasir Fakhr
Feb 21, 2018Copper Contributor
use conditional formatting with time
how to use conditional formatting with time,
If cell B is greater than 09:02:00 AM it should be highlighted in yellow,
waiting best response
Date
Time
Remarks
1-Feb-18 ...
SergeiBaklan
Feb 21, 2018Diamond Contributor
Actually the time is number. You may apply the rule like
=$B2>TIME(9,2,0)
to highlight the cells