Simple one here, i am copying some text from one sheet to another, which works great, but i need it to copy the text AND the color formatting...
Any help?
I am using 
=IF(Sheet1!A20="","",Sheet1!A20)
on Sheet2 cell A20