Write a conditional formatting rule that highlights the rows you need

App and version: {{app_and_version}}
What should be highlighted, in plain words: {{condition}}
How it should look (fill color, bold, whole row or one cell): {{highlight_style}}
The range the rule should cover, and where the data starts: {{range}}
Who uses the sheet: {{users}}

Column headers and a few sample rows:
"""
{{sample_rows}}
"""

Task:
Write the conditional formatting rule, or rules, that do this in {{app_and_version}}, so that {{users}} can see at a glance what needs attention without sorting or filtering. I want a custom formula rule I understand, not the nearest built-in preset.

Format:
1. The rule's formula in a code block, written for the top-left cell of the range, with $ signs placed so it works across the whole range. Say in one sentence why each $ is or is not there, because that is where most highlighting rules go wrong.
2. Steps to add it in {{app_and_version}}, numbered, up to 8, with the menu names as they appear there.
3. Rule order: if there is more than one rule, the order they go in and what happens when two apply to the same row.
4. Check it: three of my sample rows, saying which should be highlighted and which should not, and why.
5. What it does not catch: for example blank dates, dates stored as text, or rows added below the range, and how to cover them.

Requirements:
- Under 350 words, plus the formula.
- Use only functions available in {{app_and_version}}, and note where Google Sheets and Excel put the rule in different menus.
- No helper column unless the rule cannot be written without one; if one is needed, give its formula too.
- If the condition depends on today's date, use TODAY() so it updates itself, and say that the highlighting will change from day to day.

Example of one check row's form only: "Row 5: due date May 2, status Open, so highlighted (overdue and still open)."

If the condition is ambiguous, for example whether "due this week" means the next 7 days or the calendar week, pick one, say which, and give the formula for the other reading too.