Tuesday, December 5, 2017

yogi_Conditionally Format A Block Of Cells Depending On Current Time

Google Spreadsheet   Post  #2311

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-05-2017
question by: greenscreen20
Conditional formatting based on Time
Hi guys,

This is a bit of a 2 part question, but it doesn't seem to work well on google sheets.  It seems fairly straight forward.

I want to do a conditional format of one cell, based on the comparison of 2 different cells.

Example, a set of cells turn GREEN if the current time is greater than a certain number.  To break it down further, if it's past 6:00am I want a set of blocks to turn green.  If it turns 6:30 a different set of blocks turn green, and the ones from before go back to normal.

For some reason the sheet doesn't format properly when I try an expression.  I was doing a conditional format such as =A7>S2, comparing A7 (time in the time block) compared to S2 (current time aka =(now() - today()) ) Some of the cells change color but not in the way I would expect. Here is the spreadsheet displaying what I want without the expressions, this is an editable link so if someone has the time / knowhow I would really appreciate it! https://docs.google.com/spreadsheets/d/11YajgdnKuXFLqAOeCkVzZIzQ95fb1ew501sSEsDfJAQ/edit?usp=sharing