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
How can I do this with Google Sheets conditional formatting?