Question

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

(a) Conditional formatting
(b) Data validation
(c) Font color
(d) Cell border settings

Answer 1

Conditional formatting in spreadsheet software allows cells with values between 100 and 500 to be formatted to appear in red, unlike the other options which do not provide criteria-based formatting.

Step-by-step explanation:

Conditional formatting in spreadsheet software enables dynamic styling based on specified criteria. By setting a rule to format cells with values between 100 and 500 in red, you visually highlight data within this range for quick identification. This differs from data validation, which controls input types, and cell border settings that impact cell outlines. Changing font color through conditional formatting selectively targets values, ensuring a focused visual cue for the defined range. This powerful tool enhances data interpretation, offering a clear and efficient way to emphasize specific information within the spreadsheet.