Excel 2007 font colour formula [Closed]

Report
Posts
11
Registration date
Friday June 11, 2010
Status
Member
Last seen
October 25, 2012
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 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
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!