To format a range so that all values greater than $500 appear in red,which of the following can you use?
A) conditional formatting
B) cell formatting
C) cell styles
D) Quick Access toolbar

Question

Quizplus · Accepted Answer

Conditional formatting allows you to apply formatting to cells based on certain conditions, such as if a value is greater than a certain amount. In this case, you would use conditional formatting to make values greater than $500 appear in red. The other options (B, C, D) do not specifically allow for conditional formatting based on a value.

To Format a Range So That All Values Greater Than