I would like to have a line, border or some other distinct formatting break up my data rows when a person's name changes in a name sorted column. I have 10 people who may have 1 to 30 rows each. I could not figure out how to do this using conditional formatting. Ideally, the last row for each person would have a thick line border or a new blank row would be inserted after it.
Thank you for your help.
To add a line with conditional formatting, suppose your data is in column A starting in row 1. You can format column A to use
Format only cells that contain
Cell value | not equal to | =A2
and select a bottom border for the format. However, Excel doesn't offer a thick border in conditional formatting.
To do this with by adding a blank row involves adding another column with formulas. Conditional formatting is probably the way to go with this if you can tolerate the normal border.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks