FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Formulas to compare values (numbers and text) In a similar fashion, you can create a conditional formatting rule to compare values of two cells. For example: =$A2<$B2-format cells or rows if a value in column A is less than the corresponding value in column B.

Detailed explanation-2: -Choose Conditional Formatting in the Styles group of the Home tab. Choose Top/Bottom Rules > Above Average to open the conditional formatting dialog box. Select the down arrow and select a formatting option, such as Light Red Fill with Dark Red Text. Select OK.

Detailed explanation-3: -Apply conditional formatting so cells with a value greater than the average are formatted using a yellow fill with dark yellow text. On the Home tab, in the Styles group, click the Conditional Formatting button. Point to Top/Bottom Rules, and click Above Average.