Okay, I can't believe I can't find this on the internet, when it seems it should be so easy. Here's my problem, and how I want to solve it (other solutions would be welcomed as well).

In my Worksheet I have approximately 12000 lines that originally came from a pivot table. In the pivot table all of my "Total" lines were colored blue.

The pivot was pasted to another worksheet as Values and as Formats, so I still have Blue on my total lines.

Now I'm adding multiple calculated columns, and I want the lines that match up with the total lines to be blue as well. How do I do it?

Also, I'd like the blue lines to automaticaly fill in with the values from the last subtotal. Is there a way to automate that also through conditional formatting?