Conditional Format of Cell Range "A" Based on Value of Cell Range "B"

[mtyrrell13]

I have a need to apply conditional formatting to a range of cells based on the value of a corresponding value in another range. I have managed to do this for a single cell, but can not figure out how to apply it to the range

below is the formula that works on a single cell

=$J$7<TODAY()-30

however I need to apply it to

This is the Cell range "A" that I need to format based on the Date value in Cell Range "B"
=$A$7:$A$17,$F$7:$F$17,$K$7:$K$17,$P$7:$P$17,$U$7:$U$17,$A$23:$A$33,$F$23:$F$33,$K$23:$K$33,$P$23:$P$33,$U$23:$U$33

This is Cell Range "B" and contains dates corresponding to names in Cell Range A, I need to format Cell Range A if one of these dates is greater than 60,30, 14 days
=$E$7:$E$17,$J$7:$J$17,$O$7:$O$17,$T$7:$T$17,$Y$7:$Y$17,$E$23:$E$33,$J$23:$J$33,$O$23:$O$33,$T$23:$T$33,$Y$23:$Y$33

 

[mtyrrell13]

you are right, I had an error in my date field that was causing the issue, once I found and fixed it the formula you posted worked. However I did not fully think through the formula because I need to format the cells Red / Yellow / Green based on 30 , 14 , 7 days from todays date but only the first conditional format evaluates to true I tried the checkbox stop if true but that did not have an impact either

 

[Fluff]

Sounds like you need to re-order them, so that 30 days is first, 14 is second & 7 is at the bottom.