Hi Mark

Tanks for replay
I dont want to hide sheets.

I want to show in main sheet i.e

if sheet2!A1 value = AD,DFR<--- font.collor black, UFF<----font.collor red

and if sheet3!A1 value = AD,DFR<--- font.collor red,UFF<----font.collor black

then main sheet1!A1 shows exactly the same.

"main sheet1!A1 = from sheet2( AD,DFR<--- font.collor
red,UFF<----font.collor black,) + = from sheet3( AD,DFR<--- font.collor
red,UFF<----font.collor black,) "

hope this explain better what I need.

Regard

Yngve

"Mark Ivey" wrote:

I am confused with your request. Are you wanting to hide these other sheets
and only show your MAIN sheet?



"Yngve" wrote in message
...
Help needed

I have 4 sheets, one is mane sheet, on the main sheet I have this
formula
=sheet2!A1 & sheet3!A1& sheet4!A1
A1 contains text like this AD,DFR,UFF, some of letters have
Font,CollorNumber 3
and I want this to show in the main sheet.
Is it possible ???
I've exhausted
all the online help files I can find with no results.

Regard
Yngve