• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditionally Format Groups of Rows

In the attached file, I am trying to draw a bottom border anytime the value in column E changes. It appears that I am off by 1 row for some reason.

For example, the 1st bottom border should appear on row 12, but for some reason it appears on row 11.

What is wrong with my CF formula?
 

Attachments

  • Chandoo.org (Conditionally Format Groups of Rows).xlsx
    10.1 KB · Views: 3
Back
Top