+ Reply to Thread
Results 1 to 12 of 12

How to use SUMIF when using Conditional Formatting

Hybrid View

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,023

    Re: How to use SUMIF when using Conditional Formatting

    Unfortunately it does not, no, as there is no highlighting there.

    Please manually mock up what you want to see.
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  2. #2
    Registered User
    Join Date
    07-29-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    36

    Re: How to use SUMIF when using Conditional Formatting

    Sorry about that. So, what I have done in the new file is I have basically, fulfilled 144 + 72 = 216 worth of orders,
    as that is the maximum amount of orders that can be fulfilled (based on stock which 216).

    I highlighted Buyer 10 and Buyer and Buyer 17's orders for Product X. I am trying to find out
    how I could do this with a conditional formatting rule (if this is possible) + if I can do this
    without having to sort the row from smallest to largest or anything like that. Is that a bit clearer?
    Attached Files Attached Files
    Last edited by AliGW; 08-01-2020 at 04:27 AM. Reason: Please don't quote unnecessarily!

+ 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. Help with slow worksheet (conditional formatting & sumif formulas)
    By LordClick in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2017, 01:44 AM
  2. Sumif and Conditional Formatting
    By kgkgkg9009 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2017, 07:59 PM
  3. Conditional Formatting Formula IF or SUMIF
    By Lawman1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2017, 10:14 AM
  4. [SOLVED] Expert Needed: Conditional Formatting and SumIF/VlookUp issue (Last row)
    By newtotheblock in forum Excel General
    Replies: 4
    Last Post: 01-09-2015, 10:06 PM
  5. [SOLVED] Conditional Formatting Formula - if(and(sumif.....
    By mmaya4 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-23-2014, 02:47 AM
  6. [SOLVED] sumif with conditional formatting
    By msmathad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2013, 02:16 PM
  7. [SOLVED] Countif or Sumif based on Conditional Formatting Color
    By Kune in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 10-07-2012, 08:47 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