Machine-translated by Google. Questions are authored in English.
Top

Discussion

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 

Answer: B

Correct answer: Apply Conditional Formatting command on Format menu

Conditional formatting applies a format when a condition holds, and re-evaluates it whenever the value changes. An IF function returns a value rather than a format, and formatting the cells by hand would not follow later edits.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.