Google Spreadsheet Post #2311
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Dec-05-2017
question by: greenscreen20
https://productforums.google.com/forum/#!topic/docs/ThrfEl-r5S0;context-place=forum/docs
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/
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/
No comments:
Post a Comment