To format a cell range so that values between 100 and 500 appear in red,which of the following can you use?
A) icon sets
B) themes
C) Top/Bottom Rules
D) Highlight Cells Rules

Question

Quizplus · Accepted Answer

Highlight Cells Rules allow for custom formatting based on specific conditions, such as values between 100 and 500 appearing in red. Icon sets, themes, and Top/Bottom Rules do not offer this level of customization.

To Format a Cell Range So That Values Between 100