Conditional Formatting Rules

Set up conditional formatting rules for my Excel sheet:

**Range:** {{range}} (e.g., "A2:F500")
**Data description:** {{what_the_data_represents}}

I want to highlight:
1. {{rule_1}} (e.g., "cells in Column C > 1000 → green background")
2. {{rule_2}} (e.g., "cells in Column D with text 'Overdue' → red text, bold")
3. {{rule_3}} (e.g., "entire row where Column E is blank → yellow background")

For each rule, provide:
- The exact steps in Excel (Home > Conditional Formatting > ...)
- If a custom formula is needed, provide the formula
- The order the rules should be applied (priority matters)

Also flag if any rules might conflict with each other.