froggiebecki
New Member
- Joined
- Dec 12, 2017
- Messages
- 2
Trying to cf a range of cells that may have numbers from 0 to 10, but some will be blank.
0=green,
>0=red
blank should have no formatting
Red's no problem, but the 0 vs blank cells is whipping me.
With just $D$5:$BC$5=0 the 0 cells turn green, but so do the blank cells.
Using this formula to try to leave blank cells unformatted, but fill any that have a "o" in them.
=AND($D$5:$BC$5<>"",$D$5:$BC$5=0)
With the AND statement, nothing turns green.
What am I missing?
Thanks for looking,
Froggiebecki
0=green,
>0=red
blank should have no formatting
Red's no problem, but the 0 vs blank cells is whipping me.
With just $D$5:$BC$5=0 the 0 cells turn green, but so do the blank cells.
Using this formula to try to leave blank cells unformatted, but fill any that have a "o" in them.
=AND($D$5:$BC$5<>"",$D$5:$BC$5=0)
With the AND statement, nothing turns green.
What am I missing?
Thanks for looking,
Froggiebecki