Custom Format in Excel
Enter value Format Specified
Wow 1001 "Wow "#
Hello world [Blue][>9999]#;[Red][<1500]#;[Magenta]#;[cyan]@
Please note: The underlying value in all the cells is the same.
How it works
Rounds the number to the nearest whole number
Appends as many 0's at the end as specified in the expression
Colors any numerical value as Red. Text remains unaffected.
Colors any value as Red. Affects both Text and numbers. Numbers converted
Custom string appended before number
Numbers greater than 100 colored as blue and less then 0 colored Red.
Numbers greater than 9999 colored as blue and less then 1500 colored Red
with any other number colored Megenta.
Numbers greater than 0 colored as blue and less then 0 colored Red, any other
number colored Megenta and text colored cyan.