Excel 2007 font colour formula

Closed
bigband Posts 11 Registration date Friday 11 June 2010 Status Member Last seen 25 October 2012 - 28 Dec 2010 à 10:47
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 30 Dec 2010 à 09:52
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.


Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
30 Dec 2010 à 09:52
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