Want to create conditional formatting based on formula (mass numbers not one by one)

I would like to create conditional formatting based on a formula specific to each row of a spread sheet...

It is a inventory "watcher" which looks at current inventory and compares this to the MIN and MAX level set...

I am familiar with IF formulas, and would essentially liek one that effected font color...

So if Column A is MIN, B is MAX, and C is CURRENT... i want...

Please Login or Register  to view this content.

(cant remember if formula have to have code tags, so have done so as precaution... havent been on in a while)

Attached is the spread sheet if that helps....

got it... conditional formatting that with non-absolute references... thanks ME.

And everyone else.