I am using the numerical value of a cell in one column to change the background colour in the adjacent one using the conditional formatting tool.
I have 3 formulae which are working fine except when the source cell is empty. The “treat empty cells as zero” option is NOT turned on but the result of this formula returns the result as if it were zero. I have tried conditions using both a formula and a cell value to return either “” or a white background in the first and last positions in the condition ladder but no joy.
The formula is “IF((AND(P17>=0,P17<6)))” which works perfectly well for the value range in the source cells.
Any help would be very gratefully received:-)