Conditional Formatting | MCQs

Explanation

• In MS Excel, Conditional Formatting is in the Home tab
• ..
• 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.

• ****

  RY 16-01-2023

Explanation

When applying conditional formatting in spreadsheet software like Microsoft Excel, Google Sheets, or LibreOffice Calc, you can check conditions against:

• Cell value: You can specify a condition based on the value in a cell, such as "greater than", "less than", "equal to", etc.
• Formula: You can also specify a condition based on a formula, which can include references to other cells, functions, and operators.