Conditional Formatting on Cell that has a formula.

[cool0masty2]

I want to put CF in a cell where i have implemented a formula

	A	B	C
1	Quantity	Sold Quantity	Remaining Quantity
2	12	3	9
3	3	3	0
4	3	4	-1

<tbody>
</tbody>

I had put formula at C ---> A2-B2...
A3-B3
A4-B4...

Because C3 is 0, CF should turn the whole row to color Red
and Because C4 is -1 ( a negative value ), CF should also give it the same color, Red... but how to do it ?
I used =$C3<=0 But it messes up my whole sheet if I do any modifications in tables... https://drive.google.com/file/d/0B8Cv2clkGPzFbXhSQkpoN0VhMlk/view?usp=sharing
this happens...

 

[cool0masty2]

but there are multiple tables...
put same formula to other tables also ?

Select F5 and enter the formula:

=IF(AND(ISNUMBER(D5),ISNUMBER(E5)),D5-E5,"")

 

[Andrew Poulsom]

Yes.