creating or importing new fill patterns in Excel 2003

G

Guest

I'm looking for a way to add custom fill patterns for use in Excel. If
possible, as bitmap imports.
 
P

Peter T

Some ideas if you want your custom pattern only for some special display
purposes:

Create a textbox with dimensions of a cell, properties - Move & size with
cell.
Format fill - effect - picture (your pattern image file)
Put the cursor in the textbox
In the Input bar type an = followed by some cell reference.

or
Create textboxes to exactly fit cells and = cell ref as above.
Format each with thin grey broder
Format fill color with no fill / invisible
Add a picture to the sheet with your image, over the textboxes.
Order - send to back
or similarly format a recangle with fill effect - picture -your image

or
Format - sheet - background
applies to entire sheet and will not print

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top