SRE Documentation | Method: conditional_format_begin

conditional_format_begin_with

 
          conditional_format_begin_with(string $column, string $beginned_with_text, string $color)

This method changes the background color of any cells in a given column to any color you like if the values of these cells begin with a given sub-string parameter.

# This method is exclusive to the commercial edition and is not supported in the community edition .

# Note

If the color is omitted, red will be used.

# Parameters

Parameter	Description
$column	The column on which you want to apply this conditional formatting method.
$begin_with_text	a substring that if any cell, in the selected column, begins with, 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.

# Returns

This method returns the calling object, so it can be chained with other methods in the ‘ReportOptions’ class

# Code Example

 
           $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_begin_with("product_name", "Digital ", "#00ff00");     
$engine = new CustomEngine($report);
$report_path = $engine->create_report();

# See Also

conditional_format_equal
conditional_format_end_with
conditional_format_contain
conditional_format_between