I am trying to Total 2 cells that will have FUTURE data containing conditional formatting; however, while my data sheet is blank, I want my sum total to be blank also (not zero). A Sum value of 0 activates Red Fill conditional formatting, so the Sum cell shows 0 (Red) rather than " " (White).
In other words, I want "Blank Cell A" + "Blank Cell B" to= "Blank Cell C" until A or B contains data.
I was able to format my blank cells individually, but can't seem to format this Sum column. Any ideas?
PRINT SCREEN HELP.jpg
Bookmarks