I'm trying to check if a cell is:
- blank, and if false (not blank)
If value equals 0. I have tried:
=IF( NOT( ISBLANK($D:$D) ) & $D:$D=0 ,TRUE,FALSE)
=IF( AND( NOT( ISBLANK($D:$D) ),$D:$D=0) ,TRUE,FALSE)
I am use Excel 2013 with Conditional Formatting rule: Use a formula to determine which cells to format > Format values where this formula is true
What am I doing wrong? The problem is, the IF($D:$D=0)
recognises cells with value 0 and those which are blank as true. I only want it to recognise 0 values. Not blank.