Spreadsheet Conditional Formatting Generator — illustrative example

INPUT
Highlight rows A2:D100 when column C contains Overdue.

RESULT
Use =$C2="Overdue" for the selected range, then verify the application's conditional-formatting settings.

REVIEW
Conditional-formatting formulas depend on the selected range and relative references. State which row the rule starts from.

This is a teaching example, not a live execution record.