Put borders around separate values using Conditional formatting

Just a quick one to show you that conditional formatting is not only about coloring cells. Assuming you have a table with distinct values in column A, e.g. a customer code, a blend numbers, or anything else (see screenshot 1). You’d like to have borders between each category, just to make it neat. Just select the whole table, add a new rule for conditional formatting (see screenshot 2), use formula =$A2<>$A1 ($ are important), set a top border, validate. You’re done, see screenshot 3.

Screenshot 1, before:

Image

Screenshot 2, Conditional formatting with formula:

Image

Screenshot 3, after:

Image

Try it, you might like it.

Thomas

Advertisements

One comment on “Put borders around separate values using Conditional formatting

  1. Francesca says:

    I like to draw borders around cells and cell ranges for my presentations. Your description is understandable but for excel beginner I advise this workshop: http://www.excel-aid.com/excel-borders-drawing-borders-around-cells-and-cell-ranges.html

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s