Create a conditional format rule on A2 which says:
This will be true if both A2 equals today and B2 equals "Y." Conditional formatting rules take effect when they contain the word TRUE. Make Green the highlighted colour in this regulation. Put the normal highlighting in red, and if the conditional format is applicable, the red will take precedence.