I need to display text in 2 different font colours in Excel, any ideas how I can do this?
I.E. I have a table of 30 pairs of values, one half of the pair coloured green and one coloured red. I want to display the red values and green values together in one cell, in their respective colours.
you want to combine the 2 cells into another cell, keeping the different colours?
so:
cell1 + cell2 = cell1cell2 ?
do they have to be in the same cell, or just look like they are ?
allign the ones on the left to the right
and the ones on the right to the left
(so the text is together in the middle)
if this mucks up your sheet, you can merge the cells above and below so there is only 1 cell on each line above/below ;)
Quote from: zpyderyou want to combine the 2 cells into another cell, keeping the different colours?
so:
cell1 + cell2 = cell1cell2 ?
Exactly
Quote from: knightydo they have to be in the same cell, or just look like they are ?
allign the ones on the left to the right
and the ones on the right to the left
(so the text is together in the middle)
if this mucks up your sheet, you can merge the cells above and below so there is only 1 cell on each line above/below ;)
This would mess up the formatting in other ways because all the text needs to be aligned to one edge. Also, I doubt that this would work dynamically as I need the display to update as soon as raw data is updated.
I would suggest its not possible by the very nature of spreadsheets and how they are designed to work. Youre effectively trying to force two values to operate as one and its not going to accept it I think. I think what Alan suggests is the only method - the data will update dynamically as you would see on a spreadsheet with numerous formulas present in different cells. Evey time you update a cell it redraws the whole spreadsheet to my knowledge.
Hmm. Ive done the opposite where Ive parsed out values from single cells (alphanumeric coordinates) into multiple cells(numeric x & y), I wonder if the opposite could be done. Im sure you could combine them - though it might treat the result as a string rather than value.... but I dont think the colour formatting would be doable?
This is the closest youll get:
http://www.pcreview.co.uk/forums/thread-3730011.php