When all the numbers between 0 and 100 in a range should be displayed in Red Colour, apply
A. use =if() function to format the required numbers red
B. apply conditional formatting command on format menu
C. select the cells that contain number between 0 and 100 then click red colour on text colour tool
D. all of above
Correct Answer» B. apply conditional formatting command on format menu.