Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
I need help with a Google spreadsheet formula. This is what I'm trying to do:
Highlight the cells in “Conditional Formatting” where the time spent between 2 cells is more than 60min. In this case the B cell should be highlighted because the activity stopped for more than an hour.
Which formula to use? I try to change time format to number and compare between the cells but no success. Any idea please?
To avoid the possibility of conflicting rules, clear all conditional formatting from ColumnA (assumed because OP won't say where the data is), select it and apply a Custom formula is of:
=and(A2<>"",A1>1/24+A2)
Select your format and Done.
For your locale you might need ; rather than ,.
AND (used here to address blank cells).
With one day being one unit to Google Sheets, 1/24 is one hour.
=and(A2<>"",A1>=1/24+A2) more than 2 hours : =and(A2<>"",A1>=2/24+A2) no highlights the cells to red (stay on yellow) where 2hours past. Any idea? thank you
– La_dh
Jun 28 '17 at 17:42
