This is a tricky one (or perhaps the flu has just spread to my brain). In cell C3 I'm combining some cells (with formula =A2&", " &A3& ", " &A4&", " &A5&", " &A6&", "). All works fine. However the cells have conditional formatting based on what is in column B. How can I hold onto this conditional fomatting (which makes the text pink if B3 = done). Can I do this? It would practically save my life if I could.