Hi,
Without seeing a sample of what you are working with, it is difficult to be certain that this will work, but it definitely worth a shot. I would try the formula
Formula:
=TEXT(INDIRECT("A"&ROW()),"mm/dd/yyyy")=TEXT($B$9,"mm/dd/yyyy")
This will return a value of TRUE for all cells in column A that the rule applies to that contain the same date as cell B9 (regardless of their date format). You can use a similar formula for cells B10 and B11, or if you want to check against all 3 cells at the same time, use
Formula:
=OR(TEXT(INDIRECT("A"&ROW()),"mm/dd/yyyy")=TEXT($B$9,"mm/dd/yyyy"),TEXT(INDIRECT("A"&ROW()),"mm/dd/yyyy")=TEXT($B$10,"mm/dd/yyyy"),TEXT(INDIRECT("A"&ROW()),"mm/dd/yyyy")=TEXT($B$11,"mm/dd/yyyy"))
.
I could also do the VBA solution for you if you are still interested after seeing this solution, but I will wait for your response first, as something this simple may change your mind.
Hope this helps
Bookmarks