{"page":"\n\n
\n
\n
\n
\n
\n\nVideo\n
\n

\nHow to Format Numbers in Excel with Color-Coding and Arrows\n

\n
\n
\nGet Free Access for 10 Days!\n
\n
\n
\n
\n
\n
×
\n\n\n
\n\nPublisher:\n\nCurated Video\n\n\n
\n
\nThis tutorial demonstrates how to format numbers in Microsoft Excel without using conditional formatting. It shows how to display positive numbers in black with an up arrow and negative numbers in red with a down arrow. By utilizing the...\nThis tutorial demonstrates how to format numbers in Microsoft Excel without using conditional formatting. It shows how to display positive numbers in black with an up arrow and negative numbers in red with a down arrow. By utilizing the Format Cells feature and symbols like hash and Alt codes, you can customize the appearance of numbers based on their value, adding clarity and visual impact to your data.
0:58 How to apply formatting to numbers in cells
1:24 Creating a custom number format to cells in Excel
1:52 Adding a thousands separator using custom cell formatting
2:32 Creating custom cell formatting for positive and negative values
4:16 Colouring negative cell values as red using custom formatting
4:48 Using Alt codes to type arrows in cells
5:40 How to insert symbols in Excel
6:28 Inserting arrows next to positive or negative numbers in Excel\n
\n
\n\n
\n
\n
\n
\n

Resource Details

\n
\n
\n
\n
Curator Rating
\n
\n
\n
\n
\n
\n
Educator Rating
Not yet Rated
\n
\n
\n
\n
\n
Media Length
\n
7:57
\n
\n
\n
\n
\n
Grade
Pre-K - Higher Ed
\n
\n
\n
\n
\n
Subjects
STEM
7 more...
\n
\n
\n
\n
\n
Media Type
Instructional Videos
\n
\n
\n
\n
\n
Source:
\n
\nThe Tech Train\n\n
\n
\n
\n
\n
\n
Date
\n
2019
\n
\n
\n
\n
\n\n
Language
English
\n
\n
\n
\n
\n
Audiences
For Teacher Use
2 more...
\n
\n
\n
\n
\n
Usage Permissions
Fine Print: Educational Use
\n
\n
\n
\n
\n
\n

Additional Materials

\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Transcript\n
\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Preview\n
\n
\n
\n

Concepts

\n
\n
numbers, space, cells, microsoft excel, formatting
\n
\n\n\n
\n
\n
\n
\n

Additional Tags

\n
\n
excel, microsoft, format, format cells, positive, negative, format numbers, number formats, custom, custom format, custom cell format, conditional formatting, excel tutorial, learn excel, thetechtrain, negative number, semi colon, hand side, alt key, number pad, square brackets, hash symbol, alt 30, hash, symbol, number, show, simply, comma, represent, brackets, green, back, type, click, arrow, begin
\n
\n\n\n
\n
\n
\n
\n

Classroom Considerations

\n
Video is ad-free
\n
\n
\n

Educator Ratings

\n
\n
\n
\n
\n
\n\nShow resource details\n
\n
\n\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" aria-label=\"Play video: How to Format Numbers in Excel with Color-Coding and Arrows\" href=\"/subscription/new\">\"How\n\n
\n
\n
\n\n\n\n"}