+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting of cell value with an offset

  1. #1
    Registered User
    Join Date
    08-16-2018
    Location
    Kennewick, WA
    MS-Off Ver
    2016 Pro Plus
    Posts
    5

    Conditional Formatting of cell value with an offset

    Hello,

    I have setup K2 to change Red when it advances higher than L2. What I am trying to do is add where if the value is 10 less than the current value of L2 then it turns Yellow and when it gets to that greater than L2 value it still turns red. I have tried multiple things but haven't yet been able to make it work. Is anyone able to help me out?

    Thanks,

    Josh
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Conditional Formatting of cell value with an offset

    Hi,

    Just add a new rule

    Cell Value, Lessthan or Equal to, L2-10

    and format as yellow. See attached
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    08-16-2018
    Location
    Kennewick, WA
    MS-Off Ver
    2016 Pro Plus
    Posts
    5

    Re: Conditional Formatting of cell value with an offset

    Is there a way to keep it Yellow from then minus 10 offset up to the positive? For example in this case when K2 hits 20 it turns yellow and stays yellow from 20-30 and when it hits 30+ it turns red and stays red?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Conditional Formatting of cell value with an offset

    Modify the yellow rule to read: cell value >= L2-10
    Move the red rule above the yellow rule
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Time-Based Conditional Formatting With Offset
    By joseph.wolfenberger in forum Excel General
    Replies: 1
    Last Post: 06-21-2016, 04:04 PM
  2. [SOLVED] VBA Conditional formatting with cell offset
    By Tanabar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2014, 03:23 PM
  3. [SOLVED] Conditional Formatting Offset
    By tommy_m in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2012, 04:41 PM
  4. Conditional formatting for percent is offset
    By danl1952 in forum Excel General
    Replies: 2
    Last Post: 07-14-2012, 09:52 AM
  5. Offset in conditional formatting
    By Diddy in forum Excel General
    Replies: 1
    Last Post: 03-27-2011, 12:07 PM
  6. Offset conditional formatting
    By Ducatisto in forum Excel General
    Replies: 7
    Last Post: 10-03-2008, 03:55 AM
  7. Conditional Formatting - offset ?
    By HUMBERTDING in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-09-2008, 05:32 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