Forum Discussion
Adding bottom borders to list of names, Conditional Formatting?
- So do I have to "create a rule" first? Because I don't understand how to do that in regards to conditional formatting; also I can't read your screen shot (it's not in English) so I can't quite understand how to do what you are showing. I need the border line to fill the entire row, not just the cell the information is in. I feel like this puts me on the right path though, still not quite there. Thank you!
Attached is my sample file which should be shown in your language when it's opened.
This link explains in detail how to
OliverScheurich Sorry, this isn't working for me. The sample file just had a few letters in the cells but no other information/formulas/formatting etc. I will look at the Microsoft video/link you sent and hopefully that will provide some guidance. Thank you for trying to help.
OliverScheurich 's conditional formula does precisely what you asked for, even to the point of allowing you to underline the tens of thousands of cells to the right of your data if you have a mind to.
If it is not working for you, thee is an error in the detail of your implementation.
Even an image of the Conditional Formatting dialogue box may help us debug your formula.
Unfortunately i don't understand what you are looking for. The sample file has conditional formatting that adds bottom borders to names. It doesn't actually matter if names (Smith, Adams, Jones....) or letters (A, D, T...) are entered in order to activate the conditional format. I hope you'll find a solution for your question and thank you for this interesting question.
OliverScheurich I ended up moving over to a personal account and again tried to look at what you sent. Finally I was able to implement your instructions and it worked!! I can't thank you enough, you have saved us hours and hours of productivity, thank you so much!!!
