+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting to highlight percentage increase

  1. #1
    Registered User
    Join Date
    03-17-2015
    Location
    Ontario, Canada
    MS-Off Ver
    2011
    Posts
    10

    Exclamation Conditional Formatting to highlight percentage increase

    how do i use conditional formatting to highlight THE ENTIRE ROW in green if the sales increase is above 10%?

    Screen Shot 2015-03-17 at 4.24.03 PM.png

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,743

    Re: Conditional Formatting to highlight percentage increase

    It would be better if you post a sheet with sample data instead of a picture. Highlight a row and explain further what you want.
    You don't specify whether it would be sales increased in the very next quarter of the same year, same quarter a year later?
    A sheet with an example of what you want would be better.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula for percentage Increase and corresponding percentage decrease (and viceversa)
    By jcroque89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2015, 10:25 AM
  2. Conditional Formatting formula - Percentage increase/decrease price colour
    By appsam1990 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-21-2014, 06:14 AM
  3. vlookup in conditional formatting to to highlight percentage Ranges
    By Sd100 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-23-2013, 09:19 PM
  4. Conditional formatting for percentage increase
    By Timba in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-04-2012, 12:26 PM
  5. Replies: 2
    Last Post: 07-12-2011, 11:08 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1