+ Reply to Thread
Results 1 to 5 of 5

Outline Cells in Red That Vary by More Than a Value of 2

  1. #1
    Registered User
    Join Date
    04-05-2013
    Location
    Gurnee, IL
    MS-Off Ver
    MS365 (PC) Version 2310
    Posts
    51

    Outline Cells in Red That Vary by More Than a Value of 2

    On the attached spreadsheet, five values are entered in cells B4-F4. Conditional formatting is set up to highlight a cell if the value is below 6 or above 9. I'd also like to set up conditional formatting to outline cells in red if two values vary by more than 2. For example, if the entered values are 5.5, 5.4, 6.2, 6.8, and 7.5, the 5.4 and 5.5 values would be highlighted for being below 6. I'd also like the cells containing 5.4 and 7.5 to be outlined in red because the difference between them is 2.1, or greater than 2.
    Attached Files Attached Files

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Outline Cells in Red That Vary by More Than a Value of 2

    you would need to use the conditional formatting formula:
    =OR(B4-$B$4:$F$4>2,B4-$B$4:$F$4<-2)
    Attached Images Attached Images
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Outline Cells in Red That Vary by More Than a Value of 2

    =OR(ABS(MAX($B$4:$F$4)-B4)>2,ABS(MIN($B$4:$F$4)-B4)>2)

    as the conditional formatting formula
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Registered User
    Join Date
    04-05-2013
    Location
    Gurnee, IL
    MS-Off Ver
    MS365 (PC) Version 2310
    Posts
    51

    Re: Outline Cells in Red That Vary by More Than a Value of 2

    Thanks for your help and quick reply!

  5. #5
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Outline Cells in Red That Vary by More Than a Value of 2

    Glad to help, thanks for rep

+ 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: 1
    Last Post: 05-09-2021, 06:00 PM
  2. Putting a formula into a cell where cells vary
    By brendanc203 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2017, 07:23 AM
  3. [SOLVED] Vary number of cells to include in a SUM
    By Jitsu_g in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2013, 07:22 AM
  4. How to vary a range of cells within a FOR loop
    By reezyf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2013, 09:56 PM
  5. [SOLVED] copy a block of cells that can vary in rows and columns
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-01-2013, 07:38 PM
  6. [SOLVED] Help with NOW() Formula to vary results in different cells
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2012, 04:28 PM
  7. [SOLVED] Vary formatting rights in protected cells
    By Angus in forum Excel General
    Replies: 0
    Last Post: 08-19-2006, 10:40 AM

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