Text Colour In Linked Cell
Is there any way to carry the formatting of a cell to a linked cell,
particularly the font colour so that if the font colour is changed in the parent cell the font colour will change in the linked cell? Any help is appreciated. |
Text Colour In Linked Cell
Use conditional formatting to determine the text colour of both cells Example: Click on Cell A2 and choose Formatting Conditional Formatting Condition 1 Formula is =$a$1=1 Click the Format button. Choose a Color and OK. Click Add Condition 2 Forula is =$a$1=2 Click the Format button Choose a second color and OK Now when you enter 1 into cell A1, text in cell A2 will change to your first color, enter 2 in cell A1 - your second color appears. Enter anything else in cell A1 the text in Cell A2 reverts to black . To make a second cell change colour in unison with cell A2, copy cell A2 and Paste Special Formats. -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=529873 |
All times are GMT +1. The time now is 05:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com