Respective supplier turn into red if condition met - Condition formating

do you want to highlight any supplier that reaches 60 and WHY 60

Conditional formatting rule

=SUMIF($G$8:$G$16,$G8,$H$8:$H$16)=60

or are you after the supplier with the highest number

I dont understand why its 60 or BEW ?

we have many suppliers and they have credit limit with us.

where would that credit limit list be kept ?
I have made a table of credit limit for each supplier in columns K&L
and then looked up that value and set conditional formatting based on that value

=SUMIF($G$8:$G$16,$G8,$H$8:$H$16)>=INDEX($L$8:$L$12,MATCH($G8,$K$8:$K$12,0))

is that the sort of thing ?

just change the ranges to fit your data

The range summing , for example 10000 or more

=SUMIF($G$8:$G$10000,$G8,$H$8:$H$10000)>=INDEX($L$8:$L$12,MATCH($G8,$K$8:$K$12,0))

same for the credit limit range
INDEX($L$8:$L$100,MATCH($G8,$K$8:$K$100,0))
for say upto row 100 or more

let say you want to goto 100,000 rows adding together and you have 1000 rows of reference
and that data actually starts in row 2 in your real data

=SUMIF($G$2:$G$100000,$G2,$H$2:$H$100000)>=INDEX($L$8:$L$12,MATCH($G8,$K$8:$K$12,0))
and the reference maybe starting at row 2 on a different sheet
=SUMIF($G$2:$G$100000,$G2,$H$2:$H$100000)>=INDEX(Sheet2!$L$2:$L$100,MATCH($G2,sheet2!$K$2:$K$100,0))

Can you please tell me how did you conjoined the conditional formatting " Rules (applied in order shown)

sorry not sure what you mean.
I saw a rule already applied , so assumed you know how to add to conditional formatting

This part sums up the spend by company name
=SUMIF($G$8:$G$16,$G8,$H$8:$H$16)

>=

This looks up the company name to see how much is credit limit
INDEX($L$8:$L$12,MATCH($G8,$K$8:$K$12,0))

Then it tests to see if the sum is greater or equal to the credit limit

so you get a true or false

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
G8:H100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=SUMIF($G$8:$G$16,$G8,$H$8:$H$16)>=INDEX($L$8:$L$12,MATCH($G8,$K$8:$K$12,0))

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Administrative Note:

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

you are welcome