conditional format last value

[ajith]

Hello,
How to highlight the last cell in column of similar values in column having different sets of values

	A	B	C
1		apple
2		apple
3		orange
4		lemon
5		lemon
6		lemon
7		apple
8

<tbody>
</tbody>

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