conditional formatting does not work

[baloot21]

Hello everybody,
Assume that there is an excel page with 3 columns ( A,B,C ) , all with number format and column C is the sum of columns of A and B( with sum formula ) . Now I want to use conditional formatting for column C , so if every cell in C be equal 0 , its row changes to a desired color but I cannot do it because all cells in C have a formula ( sum ) . If column C contains numbers without any formula, it is ok . Is there any solution for this problem? Also to solve it , I make the forth column ( D ) to paste only values of C column to it but I must paste values manually , Is there any way to paste values automatically from one column to another column? Thank you in advanced.

 

[Joe4]

It should not matter whether the 0 comes from a formula, or is hard-coded (Conditional Formatting doesn't typically look at that).

What you may have is some floating arithmetic error situation going on. See: Floating-point arithmetic may give inaccurate result in Excel - Office

An easy way to fix that is to use the ROUND formula on your SUM functions, i.e.

=ROUND(SUM(A1:B1),0)

or

=ROUND(SUM(A1:B1),2)

If you are still having issues even after incorporating this, please post a sample of your data, your Conditional Formatting rules, and what your expected results should look like, for us to see.