Excel: Conditional Formatting on Cell that has a formula.


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
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...


This question generated 8 answers. To proceed to the answers, click here.

This thread is current as of October 13, 2014.


For more resources for Microsoft Excel