FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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-2: -Conditional formatting allows you to automatically apply formatting-such as colors, icons, and data bars-to one or more cells based on the cell value.

Detailed explanation-3: -Conditional formatting is used to format a cell or a range of cells based on specified criteria. In one report, you can create as many conditions as you need and each condition can apply different formatting rules.

Detailed explanation-4: -Conditional Formatting is one of the most simple yet powerful features in Excel Spreadsheets. As the name suggests, you can use conditional formatting in Excel when you want to highlight cells that meet a specified condition. It gives you the ability to quickly add a visual analysis layer over your data set.

Detailed explanation-5: -Apply conditional formatting to text 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. Point to Highlight Cells Rules, and then click Text that Contains. Type the text that you want to highlight, and then click OK.