Once we click on the icon sets, we will get various icons like Direction, Shapes, Indicators, Rating.
HOW TO CHANGE TEXT DIRECTION IN EXCEL FULL
Next, select the full column of Icon Sets and Click on Conditional Formatting and select icon sets so that we will get the option to choose the icon shapes as shown below.
![how to change text direction in excel how to change text direction in excel](https://www.tutorialspoint.com/excel/images/rotate_cell_home_tab.jpg)
HOW TO CHANGE TEXT DIRECTION IN EXCEL HOW TO
Now in this example, we will see how to display these icon sets by following the below steps.
![how to change text direction in excel how to change text direction in excel](https://i.ytimg.com/vi/--QOea9B8V8/maxresdefault.jpg)
![how to change text direction in excel how to change text direction in excel](https://1.bp.blogspot.com/-3vgjq71FnLI/XnYT4_BU0qI/AAAAAAAAAqc/K1MiItEgnIsstP4h1TkiNraNdwF6Av04QCEwYBhgL/s1600/8.jpg)
In order to display only the icon, we need to select the option called Show Icon Only check box.
![how to change text direction in excel how to change text direction in excel](https://i1.wp.com/www.myofficetricks.com/wp-content/uploads/2022/07/image-41.png)
Please select the first format rule Format all cells based on their values. On top of that, we can see various format rules.In icon sets at the bottom, we can find “More rules”, where we can apply conditional formatting over here.Here in this example, we will choose the flag icon set indicators to display the output.Once we click on the icon sets in excel, we will get various icons like Direction, Shapes, Indicators, Rating.Next, select the full column name Icon Set and click on Conditional Formatting and select Icon Sets so that we will get the option to choose the icon shapes as shown below.Drag down the formula to all cells so that we will then get the values which are shown in the below screenshot.Then next, apply the = (equal) sign in I2 and select the G2 cell to get the value in the I2 cell for applying conditional formatting.