editing cel

  • Thread starter Thread starter PeCoNe
  • Start date Start date
P

PeCoNe

A1 B1 C1 D1
OIL 0.47 16:38:40 0:03:00

in c1 current time
in d1 max delay before C1 colored red
c1 and d1 formatted 13:30:55

What formula can i use to get C1 colored red if now-c1 > d1

Thanks Peter
 
Hi Peter,

Am Wed, 27 Mar 2013 17:10:12 +0100 schrieb PeCoNe:
A1 B1 C1 D1
OIL 0.47 16:38:40 0:03:00

in c1 current time
in d1 max delay before C1 colored red
c1 and d1 formatted 13:30:55
Click to expand...

you could use in Conditional Formatting:
=MOD(NOW(),1)>C1+D1
But nothing will happen till the sheet is new calculated.


Regards
Claus Busch
 
Op 2013-03-27 17:29, Claus Busch schreef:
Hi Peter,

Am Wed, 27 Mar 2013 17:10:12 +0100 schrieb PeCoNe:


you could use in Conditional Formatting:
=MOD(NOW(),1)>C1+D1
But nothing will happen till the sheet is new calculated.


Regards
Claus Busch
Click to expand...
Hi Claus,

That solved the problem, thanks.

bye Peter
 
Back
Top