I am have an excel budget sheet with three important rows at the bottom.
1. a sum of each column.
2. a row with the copied value of the sum-value above to hava as a control.
3. a formula that subtract the above values (I would like this value to be zero as a control).
To the first and third row I would like to have conditional formatting, coloring them red if they are not the right value (i.e: the 1st row to colour red if its not the same as thr 2nd row, and the 3rd row to colour red if its not zero).
This contitional formatting only applied correct to three of my columns, and three colours red even if the values are correct.
Solved by S. F. in 26 mins