Conditional formatting allows you to select one or more cells, and create rules for when and how those cells are formatted.

You can control the cell font, fill colour and border setting, based on the selected cell's contents, or based on the contents of another cell.

If the rules (conditions) that you specified are met, then the formatting is applied.