Home / Report Question

Q. 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 on Format menu
  • C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
  • D. All of above

Correct Answer: B