Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified in the decision table.
We will show this tool's utility through examples. Selection of Active sheet Active sheet