on the home tab, in the font group, click the borders button arrow, and select more borders. in the format cells dialog, border tab, click the thickest line available in the style section. expand the color pallet and select blue accent 1. in the border section, click the button represent a bottom border