Excel 2007 font colour formula

Closed
Report
Posts
11
Registration date
Friday June 11, 2010
Status
Member
Last seen
October 25, 2012
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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.


1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month