My problem is most likely a completely trivial one, but at the moment I'm completely out of ideas.
I want to color all cells in a certain working area depending on what single digit number they contain. The conditional formatting rules I created for the numbers 1
to 9
work like a charm, but I absolutely can't get it to work for the 0
.
If I create a simple Rule, "Format only cells that contain", Cell Value equal to 0
, all cells that contain a 0 are colored, but so are also all cells that are empty.
If I try to use a formula to color the cells, it is not working at all. I tried the following formulas:
=AND($A$1:$O$35<>"",$A$1:$O$35="0")
=AND(ISNUMBER($A$1:$O$35),$A$1:$O$35="0")
and several variations of those. When I use similar formulas in normal cells, they work as expected, regarding to the TRUE
or FALSE
response. When I use them in the conditional formatting, no cell is colored.