Strike only first one MAX cell value on row

问题:

Just need help with this problem. I used this for conditional formatting: =F5:J5=MAX($F5:$J30). I have 5 columns with values which I need to filter.

It's okey but when I have the same value I need to strike only one of them not all of them.

回答1:

You want this formula:

=F5=MAX($F$5:$J$30)

That way it will only compare one cell at a time.

If what you want is the first max only then use this formula:

=AND(F5=MAX($F$5:$J$30),COUNTIF($F5:F5,F5)=1,COUNTIF($F$4:$J4,F5)=0)