Conditional Formatting: Find last row with text and make the following rows remove all formats

[lawi227]

I have a table with 3 columns. The table contains formulas in all three columns that returns data. See example below:

Column B	Column C	Column D
Person	#	#
Alex	5	4
Phil	6
Luke	19	7
John		2
Tori		2

<tbody>
</tbody>

You'll notice that after "Tori" there are blanks; however there are formula in those rows for when I add more people to my database; the formula will extract those names I add. However, visually I do not like seeing the borders around those empty boxes. How can I make the last three rows in this table not have any borders?

 

[Veritan]

Since it's just 3 rows you're talking about, have you considered simply manually hiding them? If you've got an official table (i.e., Excel recognizes it as a table and it's not just a list of data), then you can't really adjust portions of how the table looks. But you can hide specific rows if you don't want them showing up. Bear in mind that if you filter the table, the manually hidden rows will show up (provided they meet the filter criteria). However, as soon as you clear all filters from the table, the manually hidden rows will become hidden again.

 

[lawi227]

It's not in a table technically. It's just cells with borders.

I want to have the functionality that will do it automatically so I do not have to manually hide rows every time I add data.