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!
=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.
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.
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.
