Format Values where Formula is True for Whole Column

Hi
I have a table which has 7 rows in it. I want to apply conditional formatting to it for 3 different formulas that show a RAG status.
So if a value in a cell in Row 2 has a low value it is red - a medium value, amber and a high value green.
Then I want this check repeated for Row 3 etc
I have tried to set up Conditional formatting for all rows. but without creating 3 rules for each row, I cant see how to make my formula clever enough to know that it is on Row 5 so only look at a cell in Row 5 - At present they all look at a cell in Row 2, so when that is changed all RAGs for al Rows change at once.

Any help would be appreciated.

Rob

Change the formula to
=AND($N2 >0.89, $N2 <= 2)
and do the same for the other 2 formulae

Hi Guys -
Thank you Fluff that worked perfectly.
Thank you Marvin - I really liked what you have provided and whilst it wasnt quite what I asked for, I can see where it can be used and it has made my spreadsheet even better.

Thanks again all.

Glad we could help & thanks for the feedback