conditional_format_more
conditional_format_more
conditional_format_more(string $column, mixed $parameter, bool $is_or_equal , string $color )
Parameter | Description |
---|---|
$column | The column on which you want to apply this conditional formatting method. |
$parameter | a parameter that you want to use as a reference to compare each cell data in the selected column against. |
$is_or_equal | If this parameter is set to true, the comparison criteria will be "more than or equal" instead of just "more than". |
$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_more("units_in_stock", 10, true)
->conditional_format_between("list_price", 0, 100,"#014421")
->set_layout("AlignedLeft")
->set_style_name("grey");
$engine = new CustomEngine($report);
$report_path = $engine->create_report();