Highlight rows with the same date and appointment time

[Bwiles96]

I am looking for a macro to highlight rows that have an appointment that occur on the same day at the same time.
See table below for reference.

04/11/2022	11:00 AM​
04/11/2022	11:00 AM​
04/11/2022	10:00 AM​
04/11/2022	9:00 AM​
04/11/2022	8:00 AM​
04/11/2022	10:00 AM​
04/11/2022	8:00 AM​

 

[Joe4]

Welcome to the Board!

If your data is in the range A1:B8, select that rows 1:8, go to Conditional Formatting, select the formula option and enter this formula:

=COUNTIFS($A:$A,$A1,$B:$B,$B1)>1

then choose your desired highlighting color.

 

[Bwiles96]

Welcome to the Board!

If your data is in the range A1:B8, select that rows 1:8, go to Conditional Formatting, select the formula option and enter this formula:

=COUNTIFS($A:$A,$A1,$B:$B,$B1)>1

then choose your desired highlighting color.

Thank you.

If I wanted to highlight the whole row, and also highlight in different colors, would there be a way to do that? Whether that be conditional formatting or vba?

 

[Joe4]

Thank you.

If I wanted to highlight the whole row, and also highlight in different colors, would there be a way to do that? Whether that be conditional formatting or vba?

The method I gave you will highlight the entire row (note I said to "select the entire row"? Whatever is selected will be highlighted).

Unfortunately, Conditional Formatting will not do different colors for different duplicates, unless you were to set up each row manually (which probably isn't feasible with dynamic data).
Even with VBA, I cannot think up of a great way to do it, as you have no idea how many duplicates you will have, so you don't know how many colors you will need.

Perhaps someone else will be able to propose some method.

 

[Bwiles96]

The method I gave you will highlight the entire row (note I said to "select the entire row"? Whatever is selected will be highlighted).

Unfortunately, Conditional Formatting will not do different colors for different duplicates, unless you were to set up each row manually (which probably isn't feasible with dynamic data).
Even with VBA, I cannot think up of a great way to do it, as you have no idea how many duplicates you will have, so you don't know how many colors you will need.

Perhaps someone else will be able to propose some method.

I appreciate your time Joe.

Would there be a code for to alternate the color regardless? There won't be an insane amount of duplicates, they are mainly flukes or misscheduling on my teams part. I am just trying to get us organized. This happens rarely, so we wouldn't need more than like 5 colors to alternate through.

 

[Joe4]

I think this gets to be a little complex.
Take a look here, and maybe you can incorporate something like this: How to highlight duplicate values in different colors in Excel?

 

[Bwiles96]

I think this gets to be a little complex.
Take a look here, and maybe you can incorporate something like this: How to highlight duplicate values in different colors in Excel?

Thank you, Joe. You've been great help.

 

[Joe4]

You are welcome.
I hope you are able to incorporate that to do what you need.