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.