#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default Fromatting

I have a workbook with 3 spreadsheets in it. Worksheet 1 has 2 columns for
each day in the month, as well as beginning and ending balances. The beg. and
end balances are in a BOLD format, the remainder of the columns are not.
When I link a cell in wksht 1 to a cell in wksht 2 it comes over with a BOLD
format even though wksht 2 is not formatted with BOLD nor is the column in
wksht 1. Not a huge problem but just wondering why this would happen.

Thanks
--
Allan
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,805
Default Fromatting

Usually the complaing is that the formatting is NOT coming over... :-)

It does not.

Just remove the BOLD formatting from the cell ... It might have been there
before inserting the link...

How are you 'linking?'

"Flipper" wrote:

I have a workbook with 3 spreadsheets in it. Worksheet 1 has 2 columns for
each day in the month, as well as beginning and ending balances. The beg. and
end balances are in a BOLD format, the remainder of the columns are not.
When I link a cell in wksht 1 to a cell in wksht 2 it comes over with a BOLD
format even though wksht 2 is not formatted with BOLD nor is the column in
wksht 1. Not a huge problem but just wondering why this would happen.

Thanks
--
Allan

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Fromatting

I would guess that the cells have Conditional Formatting applied.


Gord Dibben MS Excel MVP

On Mon, 9 Mar 2009 08:22:08 -0700, Flipper
wrote:

I have a workbook with 3 spreadsheets in it. Worksheet 1 has 2 columns for
each day in the month, as well as beginning and ending balances. The beg. and
end balances are in a BOLD format, the remainder of the columns are not.
When I link a cell in wksht 1 to a cell in wksht 2 it comes over with a BOLD
format even though wksht 2 is not formatted with BOLD nor is the column in
wksht 1. Not a huge problem but just wondering why this would happen.

Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fromatting not possible on the cells vgneo Excel Worksheet Functions 1 October 11th 07 12:15 AM
fromatting formulae with text & dates Mike Hansen Excel Worksheet Functions 2 May 31st 06 09:40 PM
Conditional Fromatting and Formulas Mark C via OfficeKB.com Excel Worksheet Functions 5 October 26th 05 02:19 AM


All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"