Question

(1) Explain the concept of a conditional formatting.​

Answer 1

Explanation:

Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

Answer 2

Explanation:

Conditional formatting is a feature included in the popular spreadsheet creation programs Excel and Google Sheets. This feature automatically applies formatting, such as font color or bolding, to a cell when the data in that cell meets specific criteria. For example, in the image, the font color is automatically changed to red in all cells with negative values.