Forum Discussion
Solved
Excel Conditional Formatting / Modification to "Stop If True"
Good morning. TL;DR: I am trying to get a dynamic border that only applies to my very last row. THE REST: I have an Excel spreadsheet of my active cases I'm working on. I have several diffe...
- Try this:
=ROW()=COUNTA($A:$A)
Thank you both! Both formulas worked perfectly. Wish I could mark both as correct.
- Of course, there are several ways to achieve the same result. Knowing the expertise of SergeiBaklan, he will always find another way. It so happens that my formula is shorter, and thus inevitably faster, than his. The shorter and faster formula should be preferred at all times, so you don’t have to regret your choice. You made the right choice!
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
- I agree SergeiBaklan.