View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
an an is offline
external usenet poster
 
Posts: 37
Default 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