@HansVogelaar 

Thank you Hans. I believe that works but I don’t understand something. I have 2 data ranges that are Labeled “TABLEDATES” & “FEMALETABLEDATES” on the BO Mondays Tab.  When I select a date whether its from an individual being a “M” or “F” gender, the date gets filtered out from both Filtered lists.  I have tried and tried to figure this out but I just don’t understand why this is happening.  I’ve attached a workbook below so maybe you can figure this out if you would please.  My intention as well is to have the cells in both cases filled with red in Columns B & F when that date is taken/already been selected.  Conditionally formatted.

Thank you Hans

Carl

​@HansVogelaar  Thank you Hans. I believe that works but I don’t understand something. I have 2 data ranges that are Labeled “TABLEDATES” & “FEMALETABLEDATES” on the BO Mondays Tab.  When I select a date whether its from an individual being a “M” or “F” gender, the date gets filtered out from both Filtered lists.  I have tried and tried to figure this out but I just don’t understand why this is happening.  I’ve attached a workbook below so maybe you can figure this out if you would please.  My intention as well is to have the cells in both cases filled with red in Columns B & F when that date is taken/already been selected.  Conditionally formatted. Thank you HansCarl  Read More

​