conditional formatting is a feature in many spreadsheet application that allow you to apply specific formatting to cells that meet certain criteria.It is most often used on color based formatting to highlight emphasize or differentiate among data and information stored in spreadsheet