Let me rephrase my dilemna:

I am trying to get consistent formatting across all sheets (6); I have
already done this for the PrintSettings/PageSetup. And have been able
to accomplish some formatting such as row 1 being all bold with row
height 26, and text wrapped, as these cells are going to consistenly be
the same for each sheet.
What I need is script which will allow me to perhaps setup a case
structure where if it equals "sub-total" or "total" it will do
entirerow.bold, rightalign, and entirerow such and such fill pattern.
Or case if cell contains like "region" will make italic for those
cells, and so forth. Conditional formatting only works on those cells,
not the entire rows, as far as I could see..And the placement of the
cases will not fall in the same cells throughout the sheets so I need
something dynamic..
Additionally, I am looking to customize cell borders. Say I have data
through column "x", and row "#"..I only want those cells filled in thin
top/bottom/r/l/vert/horz..not the entire sheet, and then if the cell
value is "total" to fill in the row with thick border until end column
"x", not entire sheet.
I currently am working with two subs, one using a "For each ws in
Worksheets" with/endwith next ws setup for my page/printer options, AND
an array of "worksheets(array(ne,co,ia)).select" followed by select
statements. So which ever is easier to accomplish what I want, or a
completely different sub using perhaps a case structure...dunno.
Thanks for any help.