copy link
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 |
copy link
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 |
All times are GMT +1. The time now is 10:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com