Applying a Border via Conditional Formatting

GeorgieAnne​ , Great question, and yes, you can absolutely extend the conditional formatting to Columns A and B based on the values in Column C.

Here's how to do it:

1. Select the range you want to apply the formatting to—e.g., A2:B100 (adjust as needed).
2. Go to Home > Conditional Formatting > New Rule.
3. Choose “Use a formula to determine which cells to format.”
4. Enter a formula like this: =RANK($C2,$C$2:$C$100)<=3
   
   1. This checks if the value in Column C is among the top 3.
   2. Click Format, set the border to red and fill color to blue, then click OK.

   This will apply the same formatting to Columns A and B for the rows where Column C has one of the top 3 values.

   Let me know if you’d like help adapting this to dynamic ranges or using named ranges!