Automatic borders in Excel 2010

6,281

Use Conditional formatting > New Rule > "Format only cells that contain"

enter image description here

Share:
6,281

Related videos on Youtube

Joshua
Author by

Joshua

Updated on September 18, 2022

Comments

  • Joshua
    Joshua over 1 year

    I have a worksheet that automatically colors a row when column A is filled with certain text. What I want is to also have a thick black border appear above each colored cell, and not appear above any unfilled cell.