Forum Discussion
Formula Assistance
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
1 Reply
Your formula doesn't filter for M or F anywhere. Hence there is no difference. Try the attached workbook.
