Mark the fifth same Value red

Copper Contributor

Hello all,

I need your help, please.

In a column, if a value occurs 5 times, I want to mark the last value in red. There should be no criterion. All values that occur more than 5 times, the last one should be marked red.

1 Reply


Presuming the values are in A2:A31, for example:


Conditional formatting formula: