HIGHLIGHT When it's NOT TIME
In this tutorial, Andrew demonstrates how to highlight cells in Google Sheets when the input is not a valid time, emphasizing the importance of managing time effectively without strict deadlines.
Hi, I'm Andrew. Welcome to another overcaffeinated Google Sheet tutorial. We don't need deadlines. We need dead times. It's highlighting when it's not a time. If I put in a time, 5:00 a.m. totally fine. Go to format conditional formatting . Let's do this item by item. Equals time value range of B2B. Put B2 here. And it's going to update automatically over time over every single row. We also need to have if error , comma 0 in parenthesis. Then we're going to do equals zero. Put a parenthesy at the end. Go back to the beginning. and put it and and then we're going to do B2 and do this less than and then greater than two quotes, what this means is that it's not blank. Done. Build a Visual Clock How To Create a Stop Watch in Google Sheets Create a Stop Watch in a Google Sheet How to Highlight Not Time in Google Sheets