Highlight multiple min & max cells in a column based on date reference

Dear All,

I wonder if you can help.
I have a data set of >30k rows, containing many duplicate dates in Column A.
In Column B I am looking to highlight the highest value number seen across the multiple occurrences of that date
In Column C I am looking to highlight the lowest value number seen across the multiple occurrences of that date
A simple visual is attached.

I have not been able to get the formula correct within the conditional formatting. I really appreciate any feedback you may have

Thank you,

Marzban

Use this formulas in Conditional formatting (adjust the range)

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

In your sample file, select all the cells from B2 to B13, then click on Conditional Formatting | New Rule | Use a Formula... , then enter this formula into the dialogue box:

=B2=MAX(IF($A$2:$A$13=$A2,$B$2:$B$13))

click on the Format button | Fill tab and choose your colour (e.g. yellow, so it will take precedence over the colours you have manually put in and thus show that it is working). Click OK twice to exit the dialogue box.

Then select cells C2 to C13 and repeat, but using this formula instead:

=C2=MIN(IF($A$2:$A$13=$A2,$C$2:$C$13))

and maybe choosing blue as the highlight colour.

Adapt this to your real file.

Hope this helps.

Pete

Dear Pete - that was very helpful.
Thank you for taking the time to respond.
Marzban

Dear Jose - Thank you.
Both of the solutions suggested are working.
Thank you for taking the time to respond.
Marzban

You are welcome and thank you for feedback.

Do not forget to mark this thread as SOLVED.