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

[Son Raphon]

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?

 

[Son Raphon]

Just the very last one.

=AND($V5="Cash", COUNTIF($V$5:$V$50,"Cash")=COUNTIF($V$5:$V50,"Cash"))

I copied from your last to past. It's still bold all cells in category cash.

 

[Son Raphon]

FYI, I'm using with Google Sheet.

 

[Cubist]

This information should be included in the first post. There's another sub-forum for Google Sheets. They're not the same. This is for Excel only.

This should work.

=AND(V5="Cash", COUNTIF($V$5:$V$50,"Cash")=COUNTIF($V$5:$V5,"Cash"))

 

[Son Raphon]

Just the very last one.

=AND($V5="Cash", COUNTIF($V$5:$V$50,"Cash")=COUNTIF($V$5:$V50,"Cash"))

Thanks you so much.

 

[Son Raphon]

This information should be included in the first post. There's another sub-forum for Google Sheets. They're not the same. This is for Excel only.

View attachment 111256

This should work.

=AND(V5="Cash", COUNTIF($V$5:$V$50,"Cash")=COUNTIF($V$5:$V5,"Cash"))

This one is work correctly. Thanks you again.