editing cel

[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

 

[Claus Busch]

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

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


Regards
Claus Busch

 

[PeCoNe]

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

Hi Claus,

That solved the problem, thanks.

bye Peter