Home > Software design >  Conditional formatting days passed "10 day(s)"
Conditional formatting days passed "10 day(s)"

Time:12-16

Info in F cell tells us the time stamp. Corresponding G cell shows times passed. Need conditionally formatting G cells for days passed. 2 day(s) 5 day(s) 10 day(s)

Because the formula isn't straightforward I have not found a simple way to conditionally format it.

i only did dates between "1d and 3d", some of it works but when it gets to 10d it screws up, or it's all random.

enter image description here

demo sheet

  • Related