I need a “little” help here.
I want to setup a time condition where the following conditions are performed -
1. If time is greater than 4pm then the format should be bold.
2. If time is less the 4pm then the format should be italic with
a very light gray background.
I’m having a “pickle of a time” getting the condition formula to work, basically because I don’t know how to do it.
Thanks for any suggest or help.
TIME.ods (29.2 KB)
How about Cell Value is greater than 2/3 (16:00 over 24:00) and create a cell style with name After4.
Then create a second condition, Cell Value is less than or equal to 2/3 and create a cell style Before 4
TIME125315EATime.ods (21.2 KB)
This just what I needed. THANKS!
You need to make sure there are no days in the cell value, as the format may hide them.
In that case Formula is MOD(A2;1)>2/3 etc.
Similar to @EarnestAl’s suggestion. I’ve added my instructions, which should be helpfully.
I’ve also added a more elegant solution using Sheet-1 with an additional cell [B13] for entering the desired time, which the comparative times are calculated with. This is easier to reference than having to change the value — in your case, 2/3 — in the conditional formatting formulas.
TiME_KoYoTaks_121915.ods (26.0 KB)
I note that the decimal of 0.666666… is imprecise when calculating with a fraction of a double dozen (24), hence the fraction 2/3 (or 16/24) as the exact numerical value for 4 p.m.
K, thanks for the suggestion. EarnestAI does just what I need.
