+ Reply to Thread
Results 1 to 3 of 3

How to highlight cells within a row that fall within a certain range

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

    How to highlight cells within a row that fall within a certain range

    Hello,

    I have a row on a worksheet that uses formulas to give me the percentage difference between two years of data. For example a cell may display "23%" or "-14%" in regards to the differences in data from one year to the next.

    What I would like to be able to do is to highlight the cells that fall outside the range of -10% and 10%. For example if I have a cell that shows 23% or -14% I would like for those cells to be highlighted while cells that contain data within the -10% to 10% range remain normal.

  2. #2
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    901

    Re: How to highlight cells within a row that fall within a certain range

    You can use or look at conditional formatting, you can apply the logic to the range of cells and write the formula that has that condition.


    here is one example of how you can do it.
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

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

    Re: How to highlight cells within a row that fall within a certain range

    Thank you for your response.

+ 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. Counting cells that fall within a date range and that are bolded
    By Non-Expert in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-28-2018, 11:22 AM
  2. Replies: 1
    Last Post: 09-19-2017, 11:36 PM
  3. highlight the dates if it fall under certain range
    By hudson andrew in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2016, 11:25 AM
  4. Add Cells Whose Date Fall Between A Specific Range
    By STBTC in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-24-2016, 07:31 PM
  5. [SOLVED] Counting cells that fall in a date range AND meet a Yes/No condition
    By pentatonic145 in forum Excel General
    Replies: 2
    Last Post: 05-01-2012, 04:26 PM
  6. Replies: 7
    Last Post: 11-10-2009, 09:42 AM
  7. Replies: 3
    Last Post: 08-08-2005, 06:05 PM

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