Most valuable professional
  • Hot Topics

Excel Conditional Formatting on Cell that has a formula.

I want to put CF in a cell where i have implemented a formula 1 2 3 4 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... 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel