FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Excel Conditional Formatting is used to apply certain formatting to data that meets one or more conditions. Just like usual cell formatting, it lets you highlight and differentiate your data in various ways by changing cells’ fill color, font color, border styles, etc.

Detailed explanation-2: -Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.

Detailed explanation-3: -Use the Quick Analysis tool to conditionally format cells in a range that have duplicate text, unique text, and text that is the same as text you specify. You can even conditionally format a row based on the text in one of the cells in the row. Select the cells you want to apply conditional formatting to.

Detailed explanation-4: -Conditional formatting allows users to automatically apply formattings such as colours, icons, and data bars to one or more cells based on the cell value. To do Conditional formatting, users need to create a conditional formatting rule.

Detailed explanation-5: -Excel’s predefined conditional formatting, such as Data Bars, Color Scales and Icon Sets, are mainly purposed to format cells based on their own values. If you want to apply conditional formatting based on another cell or format an entire row based on a single cell’s value, then you will need to use formulas.