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

Question

Quizplus · Accepted Answer

Conditional formatting is the correct method to automatically change the color of cells based on their values. The =if() function does not directly format cells, and manually selecting cells to change their color is not practical for dynamic data or large datasets.

When All the Numbers Between 0 and 100 in a Range