Question

what is conditional formatting

Answer 1

Conditional Formatting (CF) is a tool that
allows you to apply formats to a cell or range
of cells, and have that formatting change
depending on the value of the cell or the value
of a formula. For example, you can have a cell
appear bold only when the value of the cell is
greater than 100.

Answer 2

Pick certain data according to your need