Conditional format

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

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%
 
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%
Click to expand...

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


Regards
Claus B.
 
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.
Click to expand...
Thanks Claus, it works fine.
Peter
 
Back
Top