* Please note this feature is not available in Lite and Basic versions.
- Parameters:
- $col_name: column name
- $type: CELL or ROW
- $formatoptions: array that stores condition and css style options
- Description:
- Format a cell based on the specified condition. CELL formats the a single cell. ROW formats the entire row.
$formatoption is the most important parameter which itself is an array contains three elements:
- condition,
- value,
- css.
The elements are described in details as the following:
The first parameter, condition, has the following available value.
eq: Equals
ne: Not Equals
lt: Less than
le: Less than or Equal
gt: Greater than
ge: Greater than or Equal
cn: Contains
nc: Does not Contain
bw: Begins With
bn: Not Begins With
ew: Ends With
en: Not Ends WithThe second parameter, value, is the comparing value in the right operand.
css parameter in $formattoptions is an array collection that contains css style element for current cell or row.
- Format a cell based on the specified condition. CELL formats the a single cell. ROW formats the entire row.
- Example:
1 2 3 4 5 6 7 8 9 10 11 12 13 | //Format a cell based on the specified condition $dg->set_conditional_format("orderNumber","CELL",array("condition"=>"eq", "value"=>"10107", "css"=> array("color"=>"#ffffff","background-color"=>"green"))); $dg->set_conditional_format("customerNumber","CELL",array("condition"=>"eq", "value"=>"141", "css"=> array("color"=>"red","background-color"=>"#DCDCDC"))); // Format a row based on the specified condition $dg->set_conditional_format("comments","ROW",array("condition"=>"cn", "value"=>"request", "css"=>array("color"=>"white","background-color"=>"#4297D7"))); |