Conditional formatting is the tool to change how cells appear when they meet a certain value.
Conditional formatting
It is simple to highlight specific values or make specific cells obvious using conditional formatting. This modifies a cell range's look according to a criterion (or criteria). To highlight cells that contain values that meet a specific requirement, use conditional formatting.
Utilize conditional formatting according to the text in a cell
To Know more about Conditional Formatting, Check out:
https://brainly.com/question/16014701
#SPJ4