How to mark columns/ J-AU IF Column D is >= and Column E is <=

[WarrenCarr]

I have attached an image with a rough idea of what I want. I need a way to mark the columns in row J-AU if the number in Column D is >= and Column E is <=. For example in Column D is 17 and Column E is 40 I want to mark Columns K-O. I have done this manually for some. ( See image) But what is a more efficient way using formula or conditional formatting?

Image - http://tinypic.com/r/i5cfvc/9

Thanks,
WC

 

[etaf]

use conditional formatting and a formula
=AND(J$1>=$D2, J$1<=$E2)

Select the range J2:AU?? - however far down the spreadsheet you want to go

then add the formula
=AND(J$1>=$D2, J$1<=$E2)

That should work
https://www.dropbox.com/s/h3z54jft7axe3hr/Gnatt-Chart_etaf.xlsx?dl=0