Forum Discussion
Applying a Border via Conditional Formatting
Hello All Excelers,
On a worksheet in Column A I have a set of names, in Column B have a set of dates, and in Column C I have a set of values.
The values in Column C have some Conditional Formatting (CF) to indicate the highest 3 values. The CF will make a red boarder around the cell, and make the interior cell color blue.
I want to make a CF (or anything else) that would make a red boarder and interior cell color blue for the rows in Columns A and B.
Any ideas?
Thanks
GiGi
2 Replies
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:
- Select the range you want to apply the formatting to—e.g., A2:B100 (adjust as needed).
- Go to Home > Conditional Formatting > New Rule.
- Choose “Use a formula to determine which cells to format.”
- Enter a formula like this: =RANK($C2,$C$2:$C$100)<=3
- This checks if the value in Column C is among the top 3.
- 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!
Apply conditional formatting to A1:B1000 or whatever you range with formula like =$C1>=LARGE($C$1:$C$1000,3).
In Format apply desired Border and Fill.
