Replacing one cell with another and controlling its attributes

[Thawk]

Two related questions:

1) What function can I use to replace a specific cell in spreadsheet 2 with what I type in a specific cell in spreadsheet 1 (e.g. type red in spreadsheet 1 in A1 and it will replace a blank cell A1 in spreadsheet 2 with red)? I have around a hundred spreadsheets which I need to name by typing a name in cell A1. Rather than doing this, I already have the names of the spreadsheets in a column.

2) Is there anyway to control the attributes of cells in another spreadsheet? E.g. change to bold, red and specific size font in cell A1 in spreadsheet 2 using cell A1 in spreadsheet 1.

I am not proficient at VBA or Macros so if the solution lies therin, I think I will try to manually enter the information.

Thank you.

[teylyn]

You can not change the content of a cell with a worksheet function.

If you want a cell to show the content of the other cell, then you'll have to put a cell reference in it, for instance in Sheet2!A1 use

=Sheet1!A1

The format of a cell can not be synchronised with the format of another cell. At least not without macros.

[Thawk]

I was afraid somebody would say that. I guess I will have to learn Macros and VBA one of these days.