FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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-2: -In the Conditional Formatting Rules Manager, you can choose to show formatting rules for the areas of a workbook that have rules, such as the current selection or a specific worksheet. You can then create, edit, and delete rules as well as manage the precedence of rules for the cells or worksheet you selected.

Detailed explanation-3: -They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two-or three-color gradient.

Detailed explanation-4: -You cannot use Conditional Formatting when you are in Group Mode. To ungroup worksheets, click on the tab of a sheet that’s not in the group. This will immediately takes you out of group mode. If all the sheets in the workbook are grouped together, right-click on any of the grouped sheet tabs and click Ungroup Sheets.