I am clearly missing something so simply but spent all day googling trying to figure it out and cannot. What I am trying to do is format 3 cells based on the value (%) of another cell. This may include ranges as well. I figured out the first and last one below but its the three with ranges that just dont seem to work right.

If Cell B39 is > 100% Highlight D34 through G34 Yellow - (I figured this one out easy)

If Cell B39 is >=90% and <=100% Highlight D35 through G35 Yellow
If Cell B39 is >=80% and <=89.99% highlight D36 through G36 Yellow
If Cell B39 is >=70% and <=79.99% highlight D37 through G37 Yellow

If Cell B39 is <69.99% highlight D38 through G38 Yellow. I figured this one out easy)