06-19-2019 05:19 AM
06-19-2019 05:19 AM
TL;DR: I am trying to get a dynamic border that only applies to my very last row.
I have an Excel spreadsheet of my active cases I'm working on. I have several different conditional formatting rules running, but one thing I would like to do is add a border that only activates for the last row. Essentially, a dynamic border that always underlines the lowest row.
I've tried a number of solutions that aren't working.
 I started out by trying =$A2<>"" (applied to $1:$1048576).
-- Column A is Case #, so this checks the row below my target row to see if I have entered a case number. If I have, then create a bottom border. This ended up doing the opposite of what I wanted: underlined every row except the bottom row.
 I tried =$A1<>"" (applied to $1:$1048576).
-- Checks to see if current row has a case number and applies a bottom border if so. This included my last row, but also included every other row.
 Switched to =ISBLANK(A2) (applied to $1:$1048576).
-- Checks to see if the row below my target row is blank. If it is, it applies the bottom border.
--- This almost works, but it looks awful because it applies a border to every empty row beyond that.
Which leads to my question: is there a way to modify a conditional formatting rule so that it stops after it has been true once? Stop If True typically stops running further conditional formatting rules, not the rule itself. I need to modify my rule so that once it finds a single empty row, it applies the border once and then stops running.
06-19-2019 05:44 AMSolution
06-19-2019 07:29 AM
Thank you both! Both formulas worked perfectly. Wish I could mark both as correct.
06-19-2019 08:48 AM
06-19-2019 09:17 AM
@Twifoo , I have no objections about the choice, just a comment on what faster formula is always has high priority. Maintainability and flexibility are often more important than saving of few milliseconds in performance. As an example is shifting on such scenario