Tiered Custom Number Format Based on Value

Afternoon all,

Is it possible to create the following tiered custom number format based on the following criteria:

>=1m = 1.0m
>0 = 1.0k
0 = Blank
<0 = (1.0k)
<=1m = (1.0m)

Thanks in advance,

Snook

Custom number formatting is limited in the number of conditions it can handle -- perhaps even being limited to 2 conditions. Your description says that you want 5 conditions. You can use regular conditional formatting (https://support.office.com/en-us/art...B-F1951FF89D7F ), where you have more flexibility in creating conditions and formats.

You have only supplied one format section so it is applied to all number values along with the defaults- which include - symbols for negative values. Your format code could be
#,##0.0,"k";(#,##0.0,"k")
instead.

In truth all you require is one CF rule:
=ABS(C3)>=1000000
with a format code like this
#,##0.0,"k";(#,##0.0,"k")

and then apply a regular custom number format to the cells to deal with the other conditions:
#,##0.0,"k";(#,##0.0,"k");;