Forum Discussion
Solved
Adding bottom borders to list of names, Conditional Formatting?
We use huge spreadsheets in my job and at this point I have about 250 names each day that I need to put into a spreadsheet and add a bottom border line to the last row in each name group, to separate...
- 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!
=D1<>D2
This is the rule for conditional formatting in my example.
=$D$1:$D$1000
This is the range the format applies to.
Then if i enter Patel in cell D26 this cell is underlined. If i add Patel in D26 and D27 only cell D27 is underlined.
- 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
"Use a formula to determine which cells to format"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.