Then repeat above step to select horizontal arrow and down arrow to insert them into cell H3 and cell H4.ĥ. Then in H2, click Insert > Symbol, and in the Symbol dialog, select Wingdings 3 from the Font drop-down list, and then insert a type of up arrow and click Insert to insert it. C1:C8 is the value list, F2 is the 67%., then drag fill handle down to calculate evert value line. Then type =PERCENTILE($C$1:$C$8,F2) into G2 to calculate the value line above 67%. Select a blank cell beside the data list, for instance, F2, type 67%, then in the below cells, type 33% and 0%. Have you ever tried to change these icons set colors as below screenshots shown?Īctually, there is no way that can change the conditional formatting icon set, but I can introduce a way to insert some similar icons with different colors as you need.ġ.
If the relative value is bigger than 67% of all values, the icon showed as up arrow with green, if the value is bigger than 33% but less than 67% of all values, the icon showed as horizontal arrow with yellow, if the value is smaller than 33% of all values, the icon showed as down arrow with red. While you using the conditional formatting icon set in Excel, there is three colors icon. How to change conditional formatting icon set color in Excel?
0 kommentar(er)
