A conditional formatting rule would say, "Color the cell red if the value is less than $2000." You can immediately discover which cells have values less than $2000 if you use this rule.
Conditional formatting has the following advantages:
It aids in the answering of questions that are critical in making decisions.
Guides with the use of visuals
Aids in the comprehension of crucial data distribution and variance.
Share a personalized message with your friends.