Your question is too vague. Under what criteria do the borders exist? Is it just an outline? Is it around each color?

Record a macro changing the borders. Then using the LastRow techniques, change the second range to the LastRow variable.