Prev: Invoice Numbers
Next: Excel Sheet tab names
From: Jack Deuce on 28 Feb 2010 07:52
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...
From: "David Biddulph" groups [at] on 28 Feb 2010 08:23
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" <stephen.moore(a)REMOVETOREPLYipa.net> wrote in message
news:ripko51hnsc1sh8n1i126laq9vmtmnkon0(a)4ax.com...
> 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...


From: Teethless mama on 28 Feb 2010 08:44
CF:

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



"Jack Deuce" wrote:

> 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...
> .
>
 | 
Pages: 1
Prev: Invoice Numbers
Next: Excel Sheet tab names