New rule creation advice needed / 2 conditions need to be met

Hello I am trying to make a new rule that fills the whole row if the values of 2 boxes on the same row are above 2 different values. I want to make a rule that that is true if f5>x and j5>y. Can someone help me come up with this formula ?
P.S how to copy the rule to new rows.

Formula:

Please Login or Register  to view this content.

When you say 'fills the whole row', are you talking about Conditional Formatting? If you are, you can highlight all the required rows together (ensuring row 5 is the first row) and the row references will update relatively for each row.

Thank you ! It seems that I was omitting a space between the symbols.

No it must have been something else, the spaces don't do anything - I only added them so the formula is easier to read.

good to know, thanks.

Hey man I jumped the ship by saying that it works. It fills randomly the rows. This is the formula that I use =AND( $F4>0.2, $J4>15000 ) Can you identify the problem from it ?
If it's not too much to ask can you take a direct look at the excel table here and try to check what's the problem: https://www.dropbox.com/s/qsg78q5d2j...reds.xlsx?dl=0
Thank you in advance.

It looks like you haven't applied it correctly so the row references are misaligned and you also have duplicate rules in some rows.

Firstly, clear all Conditional Formatting from your sheet.

Next, highlight just the range A5:O703

Then, go to Conditional Formatting as paste =AND($F5>0.2,$J5>15000)

That should work correctly.

Thanks that fixed it !