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
Bookmarks