Read another Excel cell formatting (Filled Colour)

[calvinfoo]

I need to read the value from another Excel file (Source) and display it on another Excel (Display).

No problem read the value, but how to read and include the format too? the Cell could be bold, filled with different cell format.

And how to make the Display Excel file auto refresh every one minute?

[Caleeco]

Hello

A few questions for you:
1. Are the source file cells conditionally formatted? or manually?
2. What are the workbook names and sheet names?
3. Which cells do you need to copy the formatting for? Do they exactly match the display file?
4. What needs to be refreshed every 1 minutes? the formatting?
5. Why do you want to refresh the diplay file so frequently? What is the puporse?

If you have existing code for these worksheets, please post it using CODE tags. We can then review and add the functionality you require

Thanks
Caleeco

[calvinfoo]

1. Are the source file cells conditionally formatted? or manually?
It is manually highlighted. It is simple Excel file.

2. What are the workbook names and sheet names?
Source.xls. Sheet1

3. Which cells do you need to copy the formatting for? Do they exactly match the display file?
Entire Sheet1. Yes, basically copy and display exactly only. A1:BB67

4. What needs to be refreshed every 1 minutes? the formatting?
Data and also the formatting

5. Why do you want to refresh the display file so frequently? What is the purpose?
One Excel for DataEntry
While another Display.xls is to display on a big screen 24/7 for viewing purposes. Unless we can both open, edit, display both file at the same time then if file is saved, then the other one who is opening the same file will also auto updated.

[calvinfoo]

Argh! stupid me. Actually I solved it while writing #5.

Silly me. Actually Share Workbook solve everything I need to do. Thanks anyway!