XL custom format vs conditional format

20210220 2255 

 

Ref

[1] "www.youtube.com/watch?v=faPSXNkU1Y0" Unusual use of Excel's Custom Number Formatting with Conditions & Symbols

 

 

Syntex

positive_number_format ; negative_number_format ; other_case_format ; text_format

 

color : [color10]

threshold ; [>0.5]

placeholder ; ,

reserved word ; #, 0, %