Highlight a cell with certain criteria

Is it possible to highlight a cell, let's say red, with certain criteria. One could be SUM funct开发者_如何学Pythonion returns a minus output.

What you are looking for is conditional formatting.
Here's a quick tutorial.

If you want something as simple as formatting negative numbers, the number formatting under Format Cells allows this. You can also use custom formats for more complex or personalized formats.

Use a custom Format mask like:

[Green]0.00_;[Red]-0.00 

If you want to highlight the cell rathe rthan the value, then use conditional formatting (as JNK has suggested)