CCC Online Test

Question : When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply


A. Use =if() function to format the required numbers red
B. Apply Conditional Formatting command from style group on Home Tab
C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D. All of above



Solution
B. Apply Conditional Formatting command from style group on Home Tab


Explanation

 conditional formatting