Help needed Highlighting Cell in a grid from 2 calculated cells

Hi and welcome to the forum

Cells cannot make other cells do anything (normally). Bur what you can do is use Conditional Formatting on your table, to make cells with-in it change color based on other criteria (like your 2 cells)

If you upload a (clean) sample workbook with dummy data, I can show you how to do it (or you can try for yourself?)

1. Please avoid the use of merged cells it at all possible, they cause more trouble than anything else.
2. your "numbers" in E13:E22 are text, not numbers, convert them to numbers.
3. you can simplify the formula in G7 from this...
=IF((SUM(((O7*N7)+(O13*N13)+(O18*N18)+(O23*N23)+(O28*N28))*5)/3) <1.7,1,(SUM(((O7*N7)+(O13*N13)+(O18*N18)+(O23*N23)+(O28*N28))*5)/3))
to this...
=if(SUMPRODUCT(N7:N30*O7:O30)*5/3<1.7,1,SUMPRODUCT(N7:N30*O7:O30)*5/3)

for the CF...
1. highlight the range you want to apply the conditional formatting to (F13:J21)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND($E13=$G$9,F$12=$G$7)

OK well what would the range be (upper and lower limits?)for the color to change then?

You can use roundup() or rounddown to force the rounding in a certain direction, applying it either to G7...
=if(SUMPRODUCT(N7:N30*O7:O30)*5/3<1.7,1,ROUNDUP(SUMPRODUCT(N7:N30*O7:O30)*5/3)) ... or rounddown

Or you could apply it to the CF formula...
=AND($E13=roundup($G$9),F$12=roundup($G$7))