Conditional Formatting tools are tools you can use to identify a set of conditions and specify the formatting if those conditions are met. You can apply conditional formatting to cells based on either the value in a cell or the results of a specified formula that returns a Boolean value.
Under what circumstances would you use conditional formatting? Provide a few practical examples.