What are some standard patterns for formatting numerical values with a wide range of values like cryptocurrency prices? [duplicate]

1. What are the types of number formatting?
2. What are the 3 conditional formatting options?
3. What formatting applies formatting to cells based on their values?

What are the types of number formatting?

An N-formatted number has an implied decimal point (for example, 2.01 formatted as N2 is 201). An R-formatted number has an explicit decimal point and truncates trailing zeros (for example, 2.123 formatted as R2 is 2.12 and 3.10 formatted as R2 is 3.1).

What are the 3 conditional formatting options?

They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two- or three-color gradient.

What formatting applies formatting to cells based on their values?

Apply conditional formatting

On the Home tab, click Conditional Formatting. Values in specific cells. Examples are dates after this week, or numbers between 50 and 100, or the bottom 10% of scores. Point to Highlight Cells Rules or Top/Bottom Rules, and then click the appropriate option.