A store manager needs to run a report of current inventory. The manager would like the report to highlight product ID numbers of items that are low in stock so that they can be reordered. Which formatting option would accomplish this?

Conditional formatting changes how cells appear when their values meet a rule. The manager can set a rule to highlight product ID numbers when the corresponding stock quantity is below a chosen threshold, making items that need reordering easy to spot. A theme or title font changes the report’s overall appearance, while an image does not identify low-stock items.

AI-written and checked against the verified answer.