Use the formula
=AND(--LEFT(A2,4)=YEAR(TODAY()),--RIGHT(A2,2)=MONTH(TODAY())) as your
condition.
Or =AND(--LEFT($A2,4)=YEAR(TODAY()),--RIGHT($A2,2)=MONTH(TODAY())) if you
want to highlight the whole row.
--
David Biddulph


"Jack Deuce" wrote in message
...
Column A is not formatted as a date but does contain the year and
month as 2010 03. How can I use Conditional Formatting to highlight
that row when it is the current month and current year?


thanks to all...