ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Fromatting (https://www.excelbanter.com/excel-discussion-misc-queries/223597-fromatting.html)

Flipper

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

Sheeloo[_3_]

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


Gord Dibben

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




All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com