FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Conditional formatting provides another way to visualize data inside a spreadsheet. Using this tool you can automatically apply formatting such as colors, icons, and data bars, to a range of cells based on a condition or cell value.

Detailed explanation-2: -The correct answer is Conditional formatting. 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.

Detailed explanation-3: -Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Click New Rule. Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.

Detailed explanation-4: -On the Home tab, under Format, click Conditional Formatting. Point to Data Bars, and then click a gradient fill or a solid fill. Tip: When you make a column with data bars wider, the differences between cell values become easier to see.

Detailed explanation-5: -Highlight rules apply color formatting to cells that meet specific criteria that you define. They are the most basic type of conditional formatting rule, and Excel provides a variety of preset highlight functions.