conditional format last value

[ajith]

Hello,
How to highlight the last cell in column of similar values in column having different sets of values
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]apple[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]apple[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]orange[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]lemon[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]lemon[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]lemon[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]apple[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So we have to highlight B3,B6 and B7.

Thanks

 

[AlanY]

try this with CF > formula

=COUNTIF($B$1:B1,B1)=COUNTIF($B:$B,B1)

 

[ajith]

Hello AlanY,
Yes it works but it highlights the empty cell,B8 also.

 

[AlanY]

try this

=AND(LEN(B1)>0,COUNTIF($B$1:B1,B1)=COUNTIF($B:$B,B1))

 

[ajith]

Hello AlanY,
Great! it works.
But I forgot to tell that I had already applied "=MOD(ROW(),2)=1" for highlighting alternate rows. So in these rows the formatting is not working. I tried to move up/stop if true options the new rule, but still the same. What to do?

Sorry to trouble you.

 

[AlanY]

keep the =MOD(ROW(),2)=1 rule in second and don't check out the stop if true, would that work for you?

 

[ajith]

I had tried that also. Not working

 

[AlanY]

id this what you're after?

https://drive.google.com/file/d/13QO2DIN-ePbjFm68uOoi48KfDD4l4aoF/view?usp=sharing

 

[ajith]

Sorry. It is working. There was an error in my formula when i typed it. Thanks a lot