I'm looking for a way to display the content (!and formating!) of one cell in a couple other cells through out the work book in excell.

The way i have it set up right now is:
On worksheet 1, in cell a1, i have to enter a variable on a saved worksheet.

On annother worksheet in the same file i have the formula writen; =worksheet1,a1

so if i type 'Sweet' into worksheet 1, a1 then:
on worksheet 2, a1, it displays 'Sweet' without me having to copy/paste. Follow me?

What i need to know how to do is:
If i need the variable (in this case "Sweet") to be BOLD and UNDERLINE, is there a way to get all the cells that copy cell a1 on worksheet 1 to copy it's formating properties?