conditional_format_contain
conditional_format_contain
conditional_format_contain(string $column, string $contained_text, string $color )
Parameter | Description |
---|---|
$column | The column on which you want to apply this conditional formatting method. |
$contained_text | a substring that if any cell, in the selected column, contains, it meets the conditional formatting criteria. Therefore, it will be colored with the given $color parameter. |
$color | This color will be used to highlight the cells that meet the conditional formatting criteria. |
$report = new ReportOptions(SRE_PUBLIC_REPORT);
$report->select_tables(array("items"))
->select_fields(array("id", "country", "list_price", "units_in_stock","product_name"))
->set_grouping(array("country"))
->conditional_format_contain("product_name", "digital","#00ff00");
$engine = new CustomEngine($report);
$report_path = $engine->create_report();