If we want to highlight only the specific city name, we can only highlight specific city names. These are possible through the conditional formatting technique.įor example, look at the below list of cities.įrom this list, let us learn some formatting techniques. How about the idea of formatting only a specific set of values from the group? If we want to find only duplicate values or find unique values. We have learned some of the basic text formatting techniques.

It can be found in the styles section of the Home tab. Let us see how to apply conditional formatting Apply Conditional Formatting Conditional formatting is a technique in Excel that allows us to format cells in a worksheet based on certain conditions. Click on this option and experiment with some techniques to see the impact. Under “Format Cell Alignment, we have many options.Under “Orientation,” we can rotate text values diagonally or vertically. The important thing under “Alignment” is the “Orientation” of the text value. We can do a left alignment, right alignment, middle alignment, top alignment, and bottom alignment.We can format the alignment of the Excel text under the “Alignment” group. Click on the drop-down list of the “Font Color” option and change as per choice.We can format the default font color (black) of text to any colors available.

If we want to apply a double underline, click on the drop-down list of underline options and choose “Double Underline.”.

The below image shows a combination of all the above three options.

To apply “Underline” formatting, use the Ctrl + U shortcut key.

To apply “Italic” formatting, use the Ctrl + I shortcut key.

We have applied the “Bold” formatting using the Ctrl + B shortcut excel key Shortcut Excel Key An Excel shortcut is a technique of performing a manual task in a quicker way.

We can see all these three options.Īs per the format, we can apply formatting to text value. For example, we can make the text value look bold, italic, and underlined. We can modify the default view of the text value. Enter the font size in numbers to see the impact.

How to angle text in excel graph