You're a sales analyst building a conditional-formatting rule that highlights the top 3 sales reps by revenue. Columns A–B contain RepName and Revenue for 10 reps.
Your task:
- In column C (Top3), write a formula that returns
"Yes" if the rep is in the top 3 by revenue, and "No" otherwise.
- The formula must drag-fill from C2 → C11.
Hint: LARGE(range, 3) returns the 3rd-largest value in the range — i.e., the cutoff for "top 3." Compare each row's revenue to that cutoff with >= (so ties at the cutoff are still flagged).
Graded cells: C5 (Davis $90k → Yes), C8 (Garcia $85k → Yes), C2 (Adams $50k → No).
Open this problem on a desktop to attempt it.