How to set bold on text on cell of last row by each category?

Son Raphon

New Member
Joined
May 11, 2024
Messages
13
Office Version
  1. 2016
Platform
  1. Windows
Dear all, I have a table that separated item by category. I want to set bold text on last cell of row by using conditional formatting.
Example: I have Col Item name and Col Amount.
Item Name, Amount
A 100
A 200,
A 300
B 50
B 100

I want to set bold on col amount with 300 for category A.
And set bold on col amount with 100 for category B.

Anyone, could you guide and help me?
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
This is for category A. Here I assumed the last row is 5, but adjust to the actual range.
Excel Formula:
=AND($A1="A", $B1=MAX(IF($A$1:$A$5="A", $B$1:$B$5)))

...and this is for category B.
Excel Formula:
=AND($A1="B", $B1=MAX(IF($A$1:$A$5="B", $B$1:$B$5)))
 
Upvote 0
This is for category A. Here I assumed the last row is 5, but adjust to the actual range.
Excel Formula:
=AND($A1="A", $B1=MAX(IF($A$1:$A$5="A", $B$1:$B$5)))

...and this is for category B.
Excel Formula:
=AND($A1="B", $B1=MAX(IF($A$1:$A$5="B", $B$1:$B$5)))
Thanks you so much for your helping.
I try to apply my task. I doesn't work correctly.
I will send by image of my task. I want to get result like this.

FYI. I'm a student of university.
 

Attachments

  • INV.jpg
    INV.jpg
    97.2 KB · Views: 16
Upvote 0
I forgot to show column number.
I send image again.
 

Attachments

  • Image1.png
    Image1.png
    37.2 KB · Views: 19
Upvote 0
Edit:
I realized you wanted the last row of each category instead of the max amount. Try this.
Book1
AB
1A1
2A2
3A1
4B1
5B0
Sheet4
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B1:B5Expression=AND($A1="A", COUNTIF($A$1:$A$5,"A")=COUNTIF($A$1:$A1,"A"))textNO
B1:B5Expression=AND($A1="B", COUNTIF($A$1:$A$5,"B")=COUNTIF($A$1:$A1,"B"))textYES
 
Last edited:
Upvote 0
Edit:
I realized you wanted the last row of each category instead of the max amount. Try this.
Book1
AB
1A1
2A2
3A1
4B1
5B0
Sheet4
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B1:B5Expression=AND($A1="A", COUNTIF($A$1:$A$5,"A")=COUNTIF($A$1:$A1,"A"))textNO
B1:B5Expression=AND($A1="B", COUNTIF($A$1:$A$5,"B")=COUNTIF($A$1:$A1,"B"))textYES

It showed the result as in image.
Could you help to check?
 

Attachments

  • Imange_2.png
    Imange_2.png
    68.3 KB · Views: 16
Upvote 0
You have one too many $ sign. Remove the last $.
 
Upvote 0
Keep like this?
=AND($V5="Cash", COUNTIF($V5:$V50,"Cash")=COUNTIF($V5:$V50,"Cash"))
 
Upvote 0
Just the very last one.
Excel Formula:
=AND($V5="Cash", COUNTIF($V$5:$V$50,"Cash")=COUNTIF($V$5:$V50,"Cash"))
 
Upvote 0

Forum statistics

Threads
1,223,908
Messages
6,175,305
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top