G GN0001 Member Mar 24, 2014 #1 If the the total of two cells in M5 and M6 equals to the value of M10, then M10 should be filled in red. How can I manage this in conditional formatting? Thanks, GN
If the the total of two cells in M5 and M6 equals to the value of M10, then M10 should be filled in red. How can I manage this in conditional formatting? Thanks, GN
iferror Member Mar 24, 2014 #2 select cell M10 and then add conditional formatting to the cell FORMULA IS and type =((M5+M6)=M10)