Thanks John! It work perfectly.

amio1955

"John C" wrote:

Assuming the formatting is going to be identical cell for cell on all sheets,
you could right click on a sheet tab name, choose select all, and then just
start your formatting. It will cover all sheets selected.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"amio1955" wrote:

Hi,

I have a doc with 255 worksheets and need to change formatting on all of
them. Is there a way to format the same cell range on multiple worksheet in
the same doc all at one time?

Thanks!