I have a df which looks like this

The uploaded picture looks like Excel. It's the way to save on Excel with color.

This page will help you. How to save pandas to excel with different colors