Conditional Formatting -- Highlight an entire row
Based on the fictitious data above, I would like to highlight the entire row when the State changes. So, I would like to highlight Row 1, Row 4, and Row 6 OR, as an alternative, highlight Row 3, Row 5, and Row 9. Can anybody help with this? I'm new to conditional formatting.