How to make script report with color format

[clarkej]

[Tutorial] Add Color to Cells in Query Report

We can add color to cells in report based on cell value. Here we have made cells in row green if Rental Payment greater than 100 else red. add following code to query_report_name.js file frappe.query_reports["Payments Received"] = { "filters": [ { "fieldname":"customer", "label": __("Customer"), "fieldtype": "Link", "options": "Customer", "width": "80" } ], "formatter":function (row, cell, value, columnDef…