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
9 work like a charm, but I absolutely can't get it to work for the
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 several variations of those. When I use similar formulas in normal cells, they work as expected, regarding to the
FALSE response. When I use them in the conditional formatting, no cell is colored.