How to set different background colors for specific rows of Excel before exporting

chikevyn

I am trying to assign different background colors to excel rows based on the unique ID before exporting it. i.e for row 1-56 assign background:#2e2e2e; row 57-100 background:#120FG3 and so on. Please how can i achieve this?

colin

Hi @chikevyn ,

This thread here shows how to set the background colour, you can use that as a template.

Cheers,

Colin