Formula to copy a cell format to another cell

[avi_sai]

Hi,
I need a formula where i can copy a cell fromat in a tab to another cell which is in different tab

 

[konew1]

Do you need do this often, so you want a macro to do it? if so then you need post more info the sheet names and the cell range and some one will help you with code.
You say you want a formula. A formula won't copy a format.
If you just want to copy a format from one place to another you should use the paste special options in xl2003 or if you have 2007+ then rightclick and the paste menu has an option to paste formats.

 

[avi_sai]

The information is contained in Main Tab in Column E starting from E105 to E291
The same format to be copied to sheets named LQ32 LQ33 LQ34 LQ36 LQ39 LQ40 LQ41 from E105 to E291

 

[konew1]

If you only have to do it 7 times...
Copy E105:E291 from the main tab.
Go to sheet LQ32, select cell E105 and paste formatting. If you can't find how, then let us know the excel version that you have.
Then Go to each of the other sheets one at a time, select E105 and do the same.

It is possible to group all 7 sheets, but I don't recommend because the risk of failing to ungroup them.