FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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. =$A2=$B2-format cells or rows if values in columns A and B are the same.

Detailed explanation-2: -Go to Home –> Conditional Formatting –> Highlighting Cell Rules –> Greater Than.. / Less Than.. Based on what option you select (greater than or less than), a dialogue box would open. Let’s say, you select the ‘Greater than’ option. In the dialogue box, enter the number in the field on the left.

Detailed explanation-3: -To remove conditional formatting from specific cells, select the cells, click the Quick Analysis button, and click Clear Format. To remove all conditional formatting from the entire worksheet, click the Conditional Formatting button on the HOME tab, point to Clear Rules, and click Clear Rules from Entire Sheet.

Detailed explanation-4: -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.