I am monitoring temperatures for office refrigeration at my work and was wondering if there was a way to have the numbers outside of the okay range to change to red. That way we can scan through the document to see when the temperatures are outside of the okay range easier.
Use >Format>Conditional>Condition … The dialog should be rather intuitive, but there is also the Calc guide, of course.