Hi everyone, I am working on an excel workbook that is designed to save time making and printing labels in bulk. NoS on the site has already helped me our hugely with one issue.
I now have an issue with writing colours that I can’t resolve. I need to create a sheet that allows someone to enter the date in blue, the month in green and the year in red in different cells. Easy enough, but I then need to create a way of combining the three cells into one cell, with the writing on different lines, whilst keeping the original colours.
I can combine the cells onto different lines using text wrapping and the Char(10) formula. However, the font colour changes to black.
Any ideas?
Many thanks,
Andy
I now have an issue with writing colours that I can’t resolve. I need to create a sheet that allows someone to enter the date in blue, the month in green and the year in red in different cells. Easy enough, but I then need to create a way of combining the three cells into one cell, with the writing on different lines, whilst keeping the original colours.
I can combine the cells onto different lines using text wrapping and the Char(10) formula. However, the font colour changes to black.
Any ideas?
Many thanks,
Andy