Pivot Table - Transfer Color Back to Source Data

[Dissb]

Hello,

I am new to the boards, but have used this website for months finding answers to various issues. Thanks so much!

Anyhow, I have some data and created a pivot table. On the pivot table, I've highlighted various rows. Is there any way I can transfer the highlighted colors back to the source data?

Data 1	Data 2	Pivot 1	Pivot 2
CAT	1	CAT	1
DOG	2	DOG	5
DOG	3

<tbody>
</tbody>

 

[Dissb]

Bump. Would really like to know if this is possible or if anyone has any ideas on a work around.