Hi I would like to use conditional formatting so that that if the result of a caculation is positive zero or negative then background colour the cell appropriately. The issue is, if the cells being used are blank then I want the result to be blank (rather than zero), so that no formatting applies.
This is what I have at the moment:
To try and get a blank target cell when E6 and G6 are blank, this seems rather ineffiecent, is there a better way of doing it?
The same with summation
=SUMIF(E6:E17,"<>""") still results in a '0' in the target cell how can I make the result blank if the range E6:E17 is blank?