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