Conditional Formatting for ddd hh:mm
 

Dear all,

Take for example if I want to set Bold / Colour font - Everyday from 1800 to
next day 0900 in a cell whom has a value in a format of ddd hh:mm

How should I go about it?

Thanks in advance!

Conditional Formatting for ddd hh:mm
 

Us conditional formatting with a formula of

=OR(A2=TIME(18,0,0),A2<=TIME(9,0,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Alexander" wrote in message
...
Dear all,

Take for example if I want to set Bold / Colour font - Everyday from 1800
to
next day 0900 in a cell whom has a value in a format of ddd hh:mm

How should I go about it?

Thanks in advance!

Conditional Formatting for ddd hh:mm
 

If you've got date *and* time in your input cell, you probably need to
change that to
=OR(MOD(A2,1)=TIME(18,0,0),MOD(A2,1)<=TIME(9,0,0) )
--
David Biddulph

"Bob Phillips" wrote in message
...
Us conditional formatting with a formula of

=OR(A2=TIME(18,0,0),A2<=TIME(9,0,0))

"Alexander" wrote in message
...
Dear all,

Take for example if I want to set Bold / Colour font - Everyday from 1800
to
next day 0900 in a cell whom has a value in a format of ddd hh:mm

How should I go about it?

Thanks in advance!