Answer the question
In order to leave comments, you need to log in
Conditional range formatting in PHPSpreadSheet by median - how to implement?
If you unpick xlsx, then the conditional formatting of the range by median looks like this:
<conditionalFormatting sqref="C6:E6 G6:I6">
<cfRule type="colorScale" priority="72">
<colorScale>
<cfvo type="min"/>
<cfvo type="percentile" val="50"/>
<cfvo type="max"/>
<color rgb="FFF8696B"/>
<color rgb="FFFFEB84"/>
<color rgb="FF63BE7B"/>
</colorScale>
</cfRule>
</conditionalFormatting>
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question