Hi once more.
Using conditional formatting, how would you write a formula to highlight cells with values equaling zero (0) but not empty?
In the document at the following link, what I need is to highlight those cells filled with the value zero "0" (excluding empty cells and those cells having zeros in digits like "1010", "0172309", "14250756", etc). I just want to get highlights on cells that say just "0" (and I repeat: not empty... Empty ones should not get colorized by conditional formatting).
The document is here:
https://dl.dropboxusercontent.com/u/43577856/20130819_indicadores_part_chandoo.xlsx
I used the following formula, but still can't figure how to achieve a different color on values equaling zero (but not empty):
=NOT(ISBLANK(C4))
If there's a formula to highlight just those zero values but not those higher than "1" (in as well as the empty ones), much better... I would really appreciate it.
Using conditional formatting, how would you write a formula to highlight cells with values equaling zero (0) but not empty?
In the document at the following link, what I need is to highlight those cells filled with the value zero "0" (excluding empty cells and those cells having zeros in digits like "1010", "0172309", "14250756", etc). I just want to get highlights on cells that say just "0" (and I repeat: not empty... Empty ones should not get colorized by conditional formatting).
The document is here:
https://dl.dropboxusercontent.com/u/43577856/20130819_indicadores_part_chandoo.xlsx
I used the following formula, but still can't figure how to achieve a different color on values equaling zero (but not empty):
=NOT(ISBLANK(C4))
If there's a formula to highlight just those zero values but not those higher than "1" (in as well as the empty ones), much better... I would really appreciate it.