Mr Excel & Excelisfun Trick 95: Conditionally Format +/- 15% Change Arrows Or Logical Formula?

[fjilfaz]

Thanks Guys..2 great minds!love both of works equally..

[ExcelIsFun]

@fjilfaz , you are welcome!

[raymondmr7even]

i am so impressed with the second man.

no parenthesis in a formula. great!

mr. excel does really well too..

[ExcelIsFun]

@raymondmr7even , page 146 in the book Slaying Excel Dragons. Even though I call the book a beginner book, it has all the foundation of Excel presented in logical order from beginning to end, including formula order of precedence!!

[raymondmr7even]

@ExcelIsFun no need.. i am satisfied with all the videos here in YT. tnx anyway.

.

.

did i get you right? it's seems like u mean something...

[ExcelIsFun]

@raymondmr7even , I do not know...

[20RoyalSuperKing]

I love your Excel wars! Keep them coming. You have all taught me a great amount.

[ExcelIsFun]

@20RoyalSuperKing , Cool1 We'll keep them coming!

[InMaCell]

Effect can also be achieved using custom number formatting and webding font

[ExcelIsFun]

@InMaCell , Love the different method!!

[krn14242]

Welcome back Guys. Sorry Mike, point to Mr. Excel this round. Loved the arrows.

[ExcelIsFun]

@krn14242 , I agree!!

[Psychotec]

@mtmassociate Mr. Excels way is great indeed. It doesnt have to be clunky though. There are ways to make it look very neat.

[ExcelIsFun]

@Psychotec , that is true!

[mtmassociate]

I like the way excelisfun managed it. seems a bit less clunky.

[ExcelIsFun]

@mtmassociate , Thanks! But I did no arrows!

[mtmassociate]

Mr. Excel, seems a bit clunky the way you accomplished that, but I am still a novice so what do I know.