I want to hide the content of all cells within a range that are holding an integer value greater than 100. How can I accomplish that? Once the cell (which has a formula) reaches a value less than 100, I want it to be displayed.
Maybe it is possible to reach, doing a conditional formatting with the text color equal to the background color.
In documentation you can find how to use Conditional Formatting:
Chapter 2 Entering, Editing and Formatting Data.
That is what I would do.