Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |