Hi all,

usually, if we want to create link to another cell, we should use "=" then
go to that cell. But can we just copy and paste it?
example;
Task 1 ...with yellow color
Task 1.1 with blue color
Task 1.2 with green color

Task 2 ...with yellow color
Task 2.1 with blue color
Task 2.2 with green color
etc

now i want to create resume for task with yellow color with link.
If i use usual way...its take much time...
can someone give me a easy way to create this resume...
wish you understand with what i want archive

thanks

reza

Linked cells do not carry formatting, only values.

Try setting up some Conditional Formatting to achieve the colored cells.


Gord Dibben MS Excel MVP

On Wed, 19 Aug 2009 03:49:01 -0700, reza
wrote:

Hi all,

usually, if we want to create link to another cell, we should use "=" then
go to that cell. But can we just copy and paste it?
example;
Task 1 ...with yellow color
Task 1.1 with blue color
Task 1.2 with green color

Task 2 ...with yellow color
Task 2.1 with blue color
Task 2.2 with green color
etc

now i want to create resume for task with yellow color with link.
If i use usual way...its take much time...
can someone give me a easy way to create this resume...
wish you understand with what i want archive

thanks

reza