Previous Topic Next Topic

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
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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
1

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
How to convert the tamil pdf file to tamil word file
varathalakshmi -
karthik -

12 responses