Conditional format

[PeCoNe]

I need to apply conditional format on col B only if col C = time
How can i do that?

DJI 16167.97 18/12 1.84%
DJT 7207.17 Close 0.0123
FTSE 6562.50 14:01:43 1.08%
NDQ 4070.06 Close 0
SP5 1810.65 18/12 1.66%

 

[Claus Busch]

Hi Peter,

Am Thu, 19 Dec 2013 14:05:40 +0100 schrieb PeCoNe:

I need to apply conditional format on col B only if col C = time
How can i do that?

DJI 16167.97 18/12 1.84%
DJT 7207.17 Close 0.0123
FTSE 6562.50 14:01:43 1.08%
NDQ 4070.06 Close 0
SP5 1810.65 18/12 1.66%

try:
=ISNUMBER(C1)
or
=C1<1
or a combination of both:
=AND(C1<1,ISNUMBER(C1))


Regards
Claus B.

 

[PeCoNe]

Claus Busch schreef op 2013-12-19 14:32:

Hi Peter,

Am Thu, 19 Dec 2013 14:05:40 +0100 schrieb PeCoNe:


try:
=ISNUMBER(C1)
or
=C1<1
or a combination of both:
=AND(C1<1,ISNUMBER(C1))


Regards
Claus B.

Thanks Claus, it works fine.
Peter