Applying Conditional Formatting in Microsoft Excel

When all the numbers between 0 and 100 in a range should be displayed in red color apply

• None
• Apply Conditional Formatting command on Format menu
• Both
• Use =if() function to format the required numbers red

Related MCQs

• Suppose there is a text in a document that is bold, Red in color with green background. We want to apply all of these formatting to another paragraph in one go, Which option will we use ?
• Where can you set the shading color of a range of cells in excel ?
• Those species which are abundant in parts of their range but gradually declining in total numbers are called _____?
• The numerical value of orange color in color code carbon resistor is ______?
• A related color scheme would be colors that are next to each other on the color ____?
• Which of the following sets is countable? cantor set , set of all real numbers , set of all rational numbers , set of irrational numbers
• Differences such as hair color, height, size and eye color are easily visible. However, some differences are not obvious but still affect learning and behavior in the classroom. This is known as?
• Who are the complaints displayed to after being launched?
• What is the risk of color blind child in a family if father is color blind but mother is normal?
• if the ratio of two numbers is 5:7 and if 5 subtracted from the sum of these two numbers, 79 obtained, then the numbers are?