Add colors to a report
I'm creating a report that will organize our merchant accounts by their status. I'll have a button with a script that will run the report. What I want to do, is also add colors to the report and this I cannot figure out how to do, although I know it'll be through a script.
So our merchants will be "submitted," "accepted," "pended," etc., and in the report, I want all of the "submitted" section to look blue, for example, all of the "accepted" rows to be green, "pended" red, etc.
Any help will be greatly appreciated. Thanks!