Conditional Format to highlight rows

[Jack Deuce]

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...

 

[David Biddulph]

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.

 

[Teethless mama]

CF:

=DATE(LEFT(A1,4),RIGHT(A1,2),1)=DATE(YEAR(TODAY()),MONTH(TODAY()),1)