Excel 2007 font colour formula
Closed
bigband
Posts
11
Registration date
Friday June 11, 2010
Status
Member
Last seen
October 25, 2012
-
Dec 28, 2010 at 10:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 30, 2010 at 09:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 30, 2010 at 09:52 AM
Hello,
I have a long list of numbers in column A some numbers are in red font,(no conditional formatting has been used),When i copy these numbers to another column using a formula in B1 = A1 the font colour changes to black.Is there a way to use a formula that will retain the original font colour.Using a simple copy&paste keeps the original font colour ok but i need to use a formula .Many thanks for help.
I have a long list of numbers in column A some numbers are in red font,(no conditional formatting has been used),When i copy these numbers to another column using a formula in B1 = A1 the font colour changes to black.Is there a way to use a formula that will retain the original font colour.Using a simple copy&paste keeps the original font colour ok but i need to use a formula .Many thanks for help.
Related:
- Excel 2007 font colour formula
- Save as pdf office 2007 - Download - Other
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Rj45 colour code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 30, 2010 at 09:52 AM
Dec 30, 2010 at 09:52 AM
Hi Bigband,
A font colour is applied to a cell and not to a cell's value.
Therefore you will need manually set the font colour for the destination cell or refer to conditional formatting or VB.
Best regards,
Trowa
A font colour is applied to a cell and not to a cell's value.
Therefore you will need manually set the font colour for the destination cell or refer to conditional formatting or VB.
Best regards,
Trowa
