Conditional format for year

[windme]

Good Morning Everyone,

Using Excel XP

In column A I have a list of different dates in this format: m/d/yyyy
eg (11/3/2006).

I want to apply a conditonal format to find any date only in 2006 but can't get it to work.

I know the formula to find today is =today() but I'm stuck on how to find the year.

Hope someone could help me out on this, thanx.

Mike

[Carim]

Hi,

=Year(today())

HTH
Carim

[windme]

Hi Carin,
For some reason when I use the formula in conditional formatting

Cell Value Is: equal to: =year(today()) it doesn't format the dates for 2006.

When I use Formula Is: =year(today()) it formats ALL the dates no matter what year it is.

Am I doing something wrong?

Thanks Mike

[Carim]

Sorry for misleading you ...

Use Formula Is
=YEAR(A1)=2006

or better
=YEAR(A1)=Year(today())

HTH
Carim

[starguy]

Hi Carin,
For some reason when I use the formula in conditional formatting

Cell Value Is: equal to: =year(today()) it doesn't format the dates for 2006.

When I use Formula Is: =year(today()) it formats ALL the dates no matter what year it is.

Am I doing something wrong?

Thanks Mike

I suppose your data is in the range of A1:A100
select this range
go to Format > Conditional Formatting

put in Formula is =YEAR(A1)=2006
and click on Formate tab and select any colour from Patterns tab

Regards.

[windme]

Thanx Carim......got it working.

Appreciate your help,

Mike

[starguy]

Sorry for misleading you ...

Use Formula Is
=YEAR(A1)=2006

or better
=YEAR(A1)=Year(today())

HTH
Carim

Hi Carim

I think better is =YEAR(A1)=2006

because 2nd formula will change the result in 2007.