+ Reply to Thread
Results 1 to 3 of 3

2 last values with conditional formatting

  1. 04-24-2021, 05:14 PM #1
    ruibarbosa
    ruibarbosa is offline
    Registered User
    Join Date
    04-30-2020
    Location
    portugal
    MS-Off Ver
    2019
    Posts
    1

    2 last values with conditional formatting

    Hello everybody.
    I need your help again !!!
    Let's say that I need a conditional formatting for the (last two values) per line, when the last is less than 75% in relation to the penultimate.
    I used 2 columns (maybe not even necessary, but I couldn't get better to give me the last two values when they are in my reference values (<= 75%) using the formula = IF ($ AG6 * 75% < = $ AH6; ""; 1).
    I couldn't get better than the example in the photo.
    Thank you in advance for a possible help.
    Health for all
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 04-25-2021, 05:44 AM #2
    etaf
    etaf is online now
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,738

    Re: 2 last values with conditional formatting

    you have also posted on another forum, always worth just mentioning that
    https://www.mrexcel.com/board/thread...tting.1169110/
    Just that someone here may do a lot of work, only to find it was solved hours ago on the other forum

    Also on this forum please see the yellow banner at the top of the thread - useful to post an actual spreadsheet here

    Are the Last 2 values always in the Same 2 columns ?
    If so then you can use a simple conditional formatting formula
    which is as posted just so that its TRUE result
    $ AH6 * 75% < = $ AG6

    Is this the expected result
    Attached Files Attached Files
    Last edited by etaf; 04-25-2021 at 06:08 AM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 04-25-2021, 05:55 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,779

    Re: 2 last values with conditional formatting

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new, I have provided the link for you this time: https://www.mrexcel.com/board/thread...tting.1169110/.)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting Template - Formatting without values
    By tkelbel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2019, 12:20 PM
  2. Conditional formatting with LEN between values
    By Legs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2016, 10:08 AM
  3. [SOLVED] Conditional formatting according to given values
    By JackXcel in forum Excel General
    Replies: 3
    Last Post: 07-17-2015, 04:47 PM
  4. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  5. Conditional formatting when values equal values from another sheet
    By brianlg in forum Excel General
    Replies: 1
    Last Post: 09-25-2013, 10:05 AM
  6. [SOLVED] conditional formatting only on certain values
    By jimboryan in forum Excel General
    Replies: 4
    Last Post: 04-17-2013, 02:12 PM
  7. Conditional Formatting... w/values?
    By gunkie in forum Excel General
    Replies: 3
    Last Post: 10-19-2006, 04:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1