Forum Discussion

dionisio_125's avatar
dionisio_125
Copper Contributor
Feb 27, 2024

create a new pattern style for filling

How to create a new pattern style for filling in a cell format in Excel?

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    dionisio_125 

    To create a new pattern style for filling in a cell format in Excel, you can follow these steps:

    1. Select the Cell or Range: Click on the cell or range of cells where you want to apply the new pattern style.
    2. Open the Format Cells Dialog: Right-click on the selected cell(s) and choose "Format Cells..." from the context menu. Alternatively, you can go to the "Home" tab on the Excel ribbon, click on the "Format" dropdown arrow in the "Cells" group, and select "Format Cells...".
    3. Go to the Fill Tab: In the "Format Cells" dialog box, navigate to the "Fill" tab.
    4. Choose a Pattern: Under the "Fill Effects" section, click on the dropdown arrow next to the "Pattern" box to see the available patterns.
    5. Create a New Pattern: If you don't find a pattern that suits your needs, you can create a new pattern by clicking on the "More Colors..." button next to the "Color" box and selecting a color for the pattern. Then, adjust the "Foreground" and "Background" colors to customize the pattern. You can also adjust the "Pattern Style" and "Pattern Color" to further customize the pattern.
    6. Preview and Apply: As you make changes, you'll see a preview of the pattern in the "Sample" section of the dialog box. Once you're satisfied with the pattern, click "OK" to apply it to the selected cell(s).
    7. Save as Custom Style (Optional): If you want to save the new pattern style for future use, you can do so by going to the "Home" tab on the Excel ribbon, clicking on the "Format Painter" button, and then selecting the cell(s) with the new pattern. This will apply the pattern to the selected cells and save it as a custom cell style.

    By following these steps, you can create a new pattern style for filling in a cell format in Excel and customize it to suit your specific needs. The exact appearance of the dialog boxes and the location of certain options might vary slightly between different versions of Excel. If you encounter any differences while following the steps, they should be minor, and the general procedure remains the same. The text was created with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.

    • daa310's avatar
      daa310
      Copper Contributor

      NikolinoDE  What you describe does NOT create a new fill pattern style.  Rather it create a custom fill color.  I actually want to create a new fill pattern style and add it to excel.  

      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        Creating a custom fill pattern style and adding it to Excel is not a built-in feature within Excel. The application offers a set of predefined patterns and does not provide an interface for creating entirely new fill patterns directly through its standard tools.

Resources