Forum Discussion
tonyb1986
Jan 26, 2023Copper Contributor
Sumif leave cell blank but still show 0 if there is a 0 in a corresponding cell
I have a project which I am really struggling with. I need the blue cell in column H to be blank if the formula does not produce a result, but I also need it to display a 0 if the blue cell in column...
NikolinoDE
Jan 26, 2023Platinum Contributor
At first glance, I would recommend conditional formatting :).
Use conditional formatting to highlight information