Conditional format using AND to highlight today's date

[test_man2]

Greetings!,
I'm trying to highlight today's date using AND because just using =DAY(TODAY()) as the formula is highlighting the same number in every row.
I have a perpetual calendar spreadsheet that is set up like this:
Column A has a 3-letter month abbreviation,
Row 7, starting at column B, has 3-letter abbreviations of the days of the week that goes out to column AL.
Here's a little snippet just to give you an idea of what it looks like.

What I'd like to do is highlight today's date in this month's row (whatever month that may be). Right now, using =DAY(TODAY()) as the Conditional Formatting formula, it highlights every number on each month. When I tried to use =AND(a25="Sep",DAY(TODAY())), it doesn't work. Here's what the formula looks like currently:

and, today (9/12) the 12 cell is highlighted. But when I add A25="Sep", the cell does not highlight.
What am I missing?

 

[Joe4]

Remove what you have now.
Then, select range B25:AL25, go to Conditional Formatting and select the "Use a Formula to Determine Which Cells to Format" option, and enter this formula:

=AND($A25="Sep",B25=DAY(TODAY()))

and choose your desired color.

 

[test_man2]

That works! Thank you!
I see the difference between what you posted and what I was using, but what makes yours work and mine not?

 

[Joe4]

I see the difference between what you posted and what I was using, but what makes yours work and mine not?

The "Cell Value=" option will ONLY look at the value of the cell that it is being applied to.
So you cannot apply it to cell B25 while also considering the value in cell A25.
You need something more robust, which is why you want the formula option, where you basically just create a boolean formula that returns TRUE or FALSE.

Note that reagrding my original formula, if you wanted to make it dynamic, to always use the current month (so you do not need to hard-code it), you could use:

=AND($A25=TEXT(TODAY(),"mmm"),B25=DAY(TODAY()))