I'm struggling with something, hope someone cal help me!

I have a worksheet whereby I want cells A-F to fill red, orange or green dependent on the range of a number contained in Cell G. I get this all set up and it works but its only filling cell A with colour. Can it be done where it fills all 6 cells across the row?

Thank you!
Kevin