> Conditional Formatting on Cell that has a formula.?

Conditional Formatting on Cell that has a formula.?

Posted at: 2014-12-18 
I want to put CF in a cell where i have implemented a formula

I want whole row to turn red if there is a 0 or a negative number...

I used =$A1<=0 But it messes up my whole sheet if I do any modifications in tables...

Here is the file : https://drive.google.com/file/d/0B8Cv2clkGPzFdW9mLTQwMkZ1NG8/view?usp=sharing