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

Conditional formatting allows you to set conditions for formatting cells based on their values. In this case, you can set a condition to format cells that are greater than $500 in red. Cell formatting and cell styles do not have the capability to set conditional formatting based on values. The Quick Access toolbar is a customizable toolbar for accessing frequently used commands, but it does not have options for formatting cells based on values.