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]

I realized I did not post the sample of the working formual that works on a single cell, I just need to apply it to a wide range of cells

=$J$7<TODAY()-30

 

[mtyrrell13]

so I can not get the entire formula to post but basically it is

equals J 7 < Today() minus 30

 

[Fluff]

Try
=E7< today()-30

PS
When using either < or > in a formula you need to add spaces either side, otherwise the board thinks that you are posting HTML code.

 

[mtyrrell13]

Thanks for the tip on posting on the board, however the suggestion provided will only apply to a single cell I need it to apply to the range provided in the first post

so basically apply conditional formatting in the first range based on the value of the corresponding date value in the second range. I can make it work on a single cell but if I do that then every cell would have to have three conditional format rules for every cell, one for format cell red, one for format cell yellow and one for format cell green

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

 

[Fluff]

Select the cells in your "A" range, then enter the formula.

 

[mtyrrell13]

not following how that would work. for example cell A7, needs to be conditionally formatted based on the date value in E7, A8 conditionally formatted based on the date value in E8, and so on

this is what I tried and I get an error

"you can not use reference operators ( such as unions intersections and ranges) or array constants for conditional formatting criteria) "

=$A$7:$A$17,$F$7:$F$17=E7<Today()-30

 

[Fluff]

Why not try what I suggested? You might be surprised

 

[mtyrrell13]

Why not try what I suggested? You might be surprised

I did and I got the error I posted

 

[Fluff]

What formula did you use? The one I showed in post#4?