Skip to main content
1 of 7

Conditional formatting for cells that have date/time withing the last 24 hours

Ok so I have a google sheet that has a col for "last updated" and each row represents a separate file. The col has the date and time that an update was placed on the file.

If the date and time IS NOT within the last 24 hours, then I want that cell to turn red.

For this example, lets say the current time is 930am, so the cells that have a time BEFORE 9:30am yesterday should turn red. The cells that have a time AFTER 9:30am yesterday should remain unaffected.

This is what I want it to look like

This is what I want it to look like

How can I do this with Google Sheets conditional formatting?