Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified in the decision table.

For the following example, you will need a database and a decision table, as shows the image: