All language subtitles for 2. Formatting Data in Excel 2016 - 2

In this video you will learn more formatting techniques.

Let us apply similar formatting for all cells that represent money select cells with discount data and

click the Format Painter tool in the clipboard.

Group select cells with list price data Excel applies the formatting of cells default to D 15 to cells

C for 2C 50.

Let us repeat the procedure for cells with net price data with cells default to these 15 selected click

the format.

Paint a tool again and select cells with net price data.

Excel applies the formatting select cells with cells amount data and click the accounting number format

tool.

Select dollar English United States in the currency dropdown list let us format sell even convinced

to look like a heading in state group click sales styles and select style heading one Excel applies

heading one style to sell even text you can fill a cell or group of cells with a specific color to make

it stand out.

Let us highlight total sales in the fourth group click the full color tool and select blue color.

Excel fills the cell with blue color the full color forms the background of the cell and any text or

number you type appears on top of this color to change the text color.

Click the font color tool.

Let us select white Excel changes the text color to white.

Next let us increase the raw height in sales.

Click the format to select raw height and type 20 in Rawhide dialog box click Okay Excel increases the

height of raw from 17 to 20 points.

We need to highlight the sales amount which are greater than 40000 to do so.

Select sales effort to F 15 then in the styles group click the conditional formatting tool.

Select highlight sales rules and then greater then excel displays the greater in dialog box type forty

thousand.

Since we need to highlight the sales amount which are greater than 40000 thousand and select green fill

with dark green text click OK.

Excel apply selected formatting to sales with more than forty thousand in sales.