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][1]][1]

**How can I do this with Google Sheets conditional formatting?**


  [1]: https://i.sstatic.net/ZhqWP.png