How to custom format a number...

[albertc30]

Hi all, again.

I hope everyone is okay.

I have stumbled uppon this lovely formatt online, when I was googling away how to show numbers in $000.000B and $000.00M, haven't found it yet. I know how to do one or the other but not the two combined,s till looking, But how do I custom format in order to show either a small triangle point up when say above 50.0% and pointing down if less than 50.0%.

Again, any help is much appreciated.

Thansk and be safe everyone.

Albert

P.S: Trying to achieve screenshot 16

 

[GraH]

Hi, The format needs to be something like this

Alternative might be to use conditional format with Icon Set

 

[albertc30]

Hi, The format needs to be something like this
View attachment 12589

Alternative might be to use conditional format with Icon Set
View attachment 12590

WOW!!!

The first option I new it was possible, but the second option, although I have played about with it I have never seen the icons settings.

I am absolutely amazed with it.

Brilliant. It's all working. I went with your first option.

I'm still trying to work it out how to show a number in just either $000.00B or $000.00M, lol...

The next step will be how to apply conditional formating to the entire row depending on the value in only one cell. I did this in the past and all I remember is that it was a nightmare.

lol

Much appreciated for your help.

Albert.

 

[GraH]

Albert, thank you for the kind feedback. Glad you like it and picked something up to experiment with. ?

 

[albertc30]

Albert, thank you for the kind feedback. Glad you like it and picked something up to experiment with. ?

People like yourself are willing to give your time and share your knowledge with the rest of us, so it's the least I can do really.

Much appreciated as always.

Now onto another issue. Still googling away.

Might post another thread soon lol..