Quite a while back I created a formula to count the number of unique items in a filtered list. For examples, see:
I decided to extend this methodology to the conditional formatting of a filtered list. The following defined name formulas are required.
(The cursor must be on A5 when the cf function is defined and applied to A5:A29)
So, before filtering, the list shows the 1st unique items highlighted in yellow.
After filtering (removing the letters b,e,f,g), the resulting filtered list looks like this.
I hope that this is another useful tool to add to your Excel bag of tricks. You can download the file from the link below. Enjoy!