Conditional formatting
 

Hi!

I have

A2 B2 C2 D2
09:00:00 x1 09:00:00 x1
(time) (action) (time) (action)

I would like , with conditional formatting, change color in D2 when C2 it
will be between 08:30:00 and 09:30:00
For another words:
If C2=+- 00:30:00 of the A2.

Thanks in advance
an

Conditional formatting
 

Try this in your conditional format.

=ABS(a2-c2)<30/(24*60) as a formula


"an" wrote:

Hi!

I have

A2 B2 C2 D2
09:00:00 x1 09:00:00 x1
(time) (action) (time) (action)

I would like , with conditional formatting, change color in D2 when C2 it
will be between 08:30:00 and 09:30:00
For another words:
If C2=+- 00:30:00 of the A2.

Thanks in advance
an

Conditional formatting
 

BR,

Exactly.
Thank you for your help.

an


"Barb Reinhardt" wrote:

Try this in your conditional format.

=ABS(a2-c2)<30/(24*60) as a formula


"an" wrote:

Hi!

I have

A2 B2 C2 D2
09:00:00 x1 09:00:00 x1
(time) (action) (time) (action)

I would like , with conditional formatting, change color in D2 when C2 it
will be between 08:30:00 and 09:30:00
For another words:
If C2=+- 00:30:00 of the A2.

Thanks in advance
an