formula for cond. format

I was hoping I could solicit some help with the following conditional formatting formatting.

In one cell I have a quanity.
In another cell I have a cost.

The cost cell should equal the quanity multiplied by 10,000

So, the formula I want to put into the cond. formatting should check to make sure if the cost cell equals the quanity cell times 10,000. If yes, then no formatting.

If no, then formatting.

Thanks.

Use cell value (a2) is not equal to a1*10000 then format into some color

a1= qty
a2= price

this is how I did it:
A1=quantity
b1=cost

-Highlight the array (lets say you have 10 rows, highlight A1:B10)
-Go to conditional format, select Formula, in the formula toolbar, type "=$B2 <>$A2*10000"
-pick a color to highlight the incorrect rows.

Hope this helps.

Thanks. How do I copy the conditional formatting into other cells so that the cell reference changes.

For example, the cond. formatting in B2 references A2.

How do I copy the cond. formatting into B3 so that it references A3?

Thanks.

if you have highlighted the range of cells when you set up the conditional format, it will automatically apply the format to all of them.

if for some reason you want to apply this format to an additional row, you can copy one of the cells with the format, then do a paste special>formats to copy just the conditional format.

I hope this helps

You guys rawk.