Hi I have hopefully a quick question.
I have two cells, the first is a hard 0 and the other is blank for a user to input a value.
They are subtracted from each other with a formula for a final solution.
I have a conditional format that says if it is plus or minus 3 it is good otherwise it is bad.
The problem I have is that the blank is treated as a 0 in excel and returns a 0 to the final value before someone even enters a number in the sheet... Any thoughts on how I can get around this? Thanks.
current 0-(blank) = 0
needed 0-(blank) = Blank, or 0-0=0, or 0-5 = -5 etc...
Bookmarks