Conditional Format Highlight Delivery Dates

[Rocky17]

Hi,

I am trying to figure out how i can use conditional formatting to highlight if a delivery date in column L,N & P is within 7 days of Column J.
If it is not then it would highlight column J cell. I have tried to use a custom formula but cant get it to work.
Example sheet attached. So in this example, Cell J5 would be highlighted as cell L5 is only 4 days before cell J5. Anything more than 7 days will not be highlighted
Hope this makes sense.

Many Thanks
Rocky

[bebo021999]

Try:
=OR(AND($J3-$L3>=0,$J3-$L3<=7),AND($J3-$N3>=0,$J3-$N3<=7),AND($J3-$P3>=0,$J3-$P3<=7))

[Rocky17]

Hi Bebo,

Your a legend! Works perfectly. Is there a way to also highlight if greater than date in Column J?

Thanks
Rocky

[bebo021999]

May be:
=OR($J3-$L3<=7,$J3-$N3<=7,$J3-$P3<=7)