Highlighting if more than 10 items with same date?

Hello!

Is there a macro to highlight a cell or cells if there are more than 10 items with the same date in a list?

I have a calendar that autopopulates and it can only do up to 10 items per date. I want to track and see if I need to add more lines or if an item will not show on the calendar due to too many with the same date already in the list.

I do not want to have to put many more lines due to all the blank space for slow weeks and making letters too small for printing.

Any help would be great, thank you!

If you have a date in column "A" that is repeated 10 or more times then this code will highlight each instance of that date or any other date with the same criteria.

Please Login or Register  to view this content.

Regards Mick

Try

Please Login or Register  to view this content.

Thank you! Is there a way to have this run automatically (highlight as soon as the 10th is entered)? Or reverse the highlighting once items have been removed so that it no longer is highlighted?

Call it from change event
To a Sheet module

Please Login or Register  to view this content.

Perfect! One last request... is there a way to ignore the blanks? The macro highlights all of the blank cells because there are more than 10...

Try chane

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.