Have you tried using the Format Painter icon? You can double-click
this if you need to apply the format to several (non-contiguous)
cells, then press <Esc when you are finished.

Hope this helps.

Pete

On Apr 24, 2:45*pm, joromajr
wrote:
-- I have been searching for a way how to duplicate cell format. *That is
the color of cell and text font and color is identical to a destination cell?
Can anyone help me Please badly need it for several worksheets.

joromajr