Home » MCQs » Microsoft Excel MCQs

Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

50. Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

1. Styling
2. Conditional Formatting
3. Compare Formatting
4. Special Formatting

Answer: B) Conditional Formatting

Explanation:

By using the "Conditional Formatting" feature, we can apply special formatting based on the conditions.