Surfacing data quality issues with colors

You're a project coordinator at Horizon PMO. Your team lead wants to spot data quality issues in the project tracker before the quarterly review. Use Copilot to add two conditional formatting rules: first highlight any missing or blank values in the table, then highlight duplicate values in the Owner column to see who is managing the most projects. Verify the scope of each rule, then answer a question about what you found.