Excel Guides

How to Create Diagonal Borders in a Conditional Format in Excel

Creating diagonal borders in a conditional format in Excel can be a bit tricky, but it is definitely possible! Here's how to do it:

  1. First, select the cells that you want to apply the conditional format to. In this example, we'll select cells A1:D4.
  2. Next, go to the Conditional Formatting menu and choose New Rule. A new dialog box will appear.
  3. In the Select a Rule Type section, choose Format only cells that contain. Then, click the Format... button.
  4. A new dialog box will appear. In this dialog box, you'll need to select the Fill tab and then choose the color that you want your diagonal border to be. In this example, we'll choose green.
  5. After you've chosen your color, click the OK button twice to close both dialog boxes. Your selected cells should now have a green diagonal border!


Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.