Conditional Formatting - Multiple Columns

Hello,

I want to be able to apply the conditional formatting to multiple cells/rows. When I put in formula it just applies it to the first row.

For example:

I highlighted all columns a through c and put in the formula, =AND(B2>500,C2>6), when I click apply, it only works for column A. but has $A$1:$C$6, in the applies to section.


I want it all the rows as in example columns f through h.

How do I get conditional formatting to apply to all cells, not just first column?

See attached file for reference.

Thanks

yes it did thanks...