Conditional format depending on a cell value range

[SimonJensenAus]

Hello,
I was trying to create a conditional formatting rule dependent on the value in column A.
ie:
if values in Row 3 B5-G5 go above 1
if values in Row 4 B5-G5 go above 2
if values in Row 5 B5-G5 go above 10
But it doesn't seem to be working, any ideas on how I can achieve this as in the picture?

 

[Dan_W]

Based on exactly how it appears in the screen capture, try the following - Select the bottom option "Use a formula..." and in the formula box type:

=G8>$A8

Select your preferred formatting - light green background, etc. Then keep clicking ok until you're back at the worksheet. How you've selected the cells in this screen capture is important because you will see that amongst the selected cells the bottom right is in white? That's why I've used G8 in the formula. Let me know how it goes!