Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
28
Views
Topic starter
I need to show the highest values per folder in a table with Conditional formatting:
In the example I have set the conditional formatting manually per folder-group but would need to be able to apply one formula for the whole range.
Do you have a suggestion how I could isolate the range per folder to find the highest value(s) per folder?
The example workbook is attached.
GrtZ, BartH_NL
Posted : 21/07/2024 11:05 am
Hello,
No file attached, but test if following conditional formula works. I assume you have Excel 2019 or newer.
=MAXIFS($D:$D,$A:$A,$A2)=$D2
Br,
Anders
Posted : 23/07/2024 5:16 pm
Topic starter
Mange tak, Anders.
With a slight tweak, it worked.
=MAXIFS($D:$D,$A:$A,$A2)=C2
GrtZ, BartH
Posted : 24/07/2024 4:08 am
