Conditional Formatting Formula For Current Month

[jrusso]

It looks like this combines rows N through S
I want to highlight current month

JAN	1-Jan-13	31-Jan-13
FEB	1-Feb-13	28-Feb-13
MAR	1-Mar-13	31-Mar-13

<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>

APR

1-Apr-13

30-Apr-13

<tbody>
</tbody>

<tbody></tbody>

 

[Snakehips]

jrusso,

Try something like

=MONTH(A1)=MONTH(TODAY())

as your conditional formatting rule.


Edit A1 as necessary if not in your data range.

Hope that helps.