+ Reply to Thread
Results 1 to 2 of 2

Highlight cells based on Percentage value

  1. #1
    Registered User
    Join Date
    06-23-2021
    Location
    Pennsylvania,USA
    MS-Off Ver
    2016
    Posts
    5

    Highlight cells based on Percentage value

    Hello,

    I have a large set of date in columns where at the bottom of my columns I have a specific row that lists percentage change in data from the previous year. For example I may have one cell in the row stating 3%, another 27% and another may even have a negative value such as -64%.

    What I would like to do is be able to highlight the cells within the row which fall outside of a particular % range. For example if a cell value is between 10% and -10% I would like for it to remain normal, but if the cell is higher than 10% or lower than -10% then I would like for it to be highlighted.

    Thank you!
    Last edited by blevinsj; 06-29-2021 at 07:33 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Highlight cells based on Percentage value

    You'll want to put Filters on your data (Data / Filter) and then put in your Greater Than and Less than amounts (>= -.10 AND <= .10) ...Number Filters/ Custom Filter

+ 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. Replies: 3
    Last Post: 01-11-2021, 01:22 PM
  2. [SOLVED] Conditional format formula to highlight cells with a percentage
    By fumusic in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2019, 10:02 AM
  3. [SOLVED] color highlight a group of cells based on specific cells' value
    By jilaba in forum Excel General
    Replies: 4
    Last Post: 03-04-2017, 09:05 AM
  4. [SOLVED] Count cells in row based on cell value, highlight row if wrong number or cells.
    By gutterball in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-11-2014, 04:00 PM
  5. Replies: 2
    Last Post: 04-04-2013, 12:44 AM
  6. [SOLVED] Highlight only cells with percentage
    By sans in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-02-2013, 04:30 PM
  7. Replies: 4
    Last Post: 01-03-2013, 12:25 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