On 7 Nov 2005 20:05:45 GMT, John Persons wrote:

Ron Rosenfeld wrote in
:

Try this. I've not done extensive testing, but I think it will work
pretty close to what you want, and might even properly handle
different sized fonts.

Thanks again, Ron! I have been messing around with it and it seems to work well.
Is there an easy method that would allow me to set particular cells in the range to
a different format? That way I could use this as the default format for the
worksheet, but some cells could be formatted differently.

I suppose I could define AOI to be multiple ranges by editing the VBA code whenever
I need to format a cell differently, but that would be a pain. If there is a
clever way to make the macro skip over any cells in AOI that have been formatted
differently, that would be great.

Well, you'd have to know in advance what format to check for, and if it's
already in the cell, don't reformat it. Or some other common characteristic of
the cells to be formatted (or not formatted).

You'd also have to be sure that your "excluded formats" don't include any of
these custom formats.

Another approach would be to select the cells you wish to format (or not
format) and include(exclude) those cells that are selected.

Think about what sort of approach you want to take.


--ron