Conditional Formatting using the intersection of Two Values

Originally Posted by JeteMc

Assuming that the instructions given in the file meant that you wanted L3 and M3, as opposed to L4, bordered in red, use the following CF rule (for the right side of the box)

Or a single rule that works for both boxes

=AND(MAX($B$1:B$1)=DAY(TODAY()),MONTH($A2)=MONTH(TODAY()),YEAR($A2)=YEAR(TODAY()))

Another method came to mind after posting my original suggestion, which uses less functions (single rule version to format both boxes).

=DATEVALUE(MAX($B$1:B$1)&TEXT($A2,"\/mm/yyyy"))=TODAY()

I was trying to get it down to something on the lines of =($A2+B$1-1)=TODAY() but that would be prone to errors several times per year, and I couldn't see a way to correct it without making it longer than the original formula.