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

Download from: http://people.highline.edu/mgirvin/ExcelIsFun.htm

See how to conditionally format end stock values that have increased or decresed by plus or minus 15%. See Mr Excel use the up and down arrows available in Excel 2007 or later and see Excelisfun use TRUE/FALSE Logical Formula to format values with a change of 15% or above as green and -15% or less as red. See the Conditional Format Dialog Box to add more than one rule

Category:

Education

Tags:

• Excel
• 2003
• 2007
• 2010
• Mike
• excelisfun
• Girvin
• Highline
• Community
• College
• Bill
• Mr
• Jelen
• Slaying
• Dragons
• conditionally
• format
• end
• stock
• values
• that
• have
• increased
• or
• decresed
• by
• plus
• minus
• 15%.
• See
• use
• the
• up
• and
• down
• arrows
• TRUE/FALSE
• Logical
• Formula
• to
• Conditional
• Format
• Dialog
• Box
• add
• more
• than
• one
• rule

[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...

[ExcelIsFun]

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

[20RoyalSuperKing]

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

[ExcelIsFun]

@InMaCell , Love the different method!!

[ExcelIsFun]

@krn14242 , I agree!!