How to use Conditional Formatting between a cell pulling info from a date and comparign to a cell that includes only text
<p>I have an Excel spreadsheet that has sections broken out by month. The headers are individual month names, not dates. Each of these is color-coded to match the month. I have a single cell set aside to display the current month (using the TODAY function). I want to be able to style the cell depending on which month of the year it is.</p>

<p>I set 12 conditional formatting rules to check the cell against. I started out by using ="November" (as an example), but it doesn't seem to equate (TODAY()) with the word "November," so the rule doesn't apply. Either I need a new formula for the cell or there's some formula I have to use in the conditional formatting to get it to recognize the similarity between a date-formatted cell and a text-formatted cell.</p>

<p>Any ideas?</p>