You can set up conditional formats within cells that determine the formatting of the cell based on the outcome of a conditional operation. You can use rules or comparison operators in the conditional format.

For more information, refer to Using Conditional Formatting of Cells.