FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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-2: -On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Top/Bottom Rules. Select the command you want, such as Top 10 items or Bottom 10 %. Enter the values you want to use, and then select a format.

Detailed explanation-3: -On the HOME tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Manage Rules.

Detailed explanation-4: -To apply conditional formatting in Excel, select the worksheet cells to which to apply conditional formatting. Then click the “Conditional Formatting” button in the “Styles” button group on the “Home” tab of the Ribbon.