Conditional Formatting Rules Designer

Help me create conditional formatting rules for my spreadsheet:

**Data to Format:**
- Range to apply formatting: [e.g., B2:B100]
- Data type in range: [Numbers / Text / Dates / Percentages]
- Current data sample: [provide a few example values]

**Formatting Goals:**
- What pattern to highlight: [describe what you want to stand out]
- Color scheme preference: [traffic light / heat map / custom colors]
- Multiple conditions: [Yes/No - list all conditions]

**Specific Rules Needed:**
1. [Condition 1: e.g., "Values above 100 should be green"]
2. [Condition 2: e.g., "Values below 50 should be red"]
3. [Condition 3: add more as needed]

**Advanced Options:**
- Based on another cell's value: [Yes/No]
- Formula-based rules: [Yes/No]
- Data bars or icon sets: [Yes/No]
- Entire row highlighting: [Yes/No]

Please provide:
1. Step-by-step formatting instructions
2. Custom formulas for formula-based rules
3. Rule order/priority recommendations
4. Color accessibility considerations
5. Tips for maintaining formatting with new data