Conditional Formatting
 

Dear experts,

I've a column in date format "dd/mmm/yy", such as:

08-Jan-07
12-Feb-07
21-Jan-07
18-Mar-07

When I want to apply conditional formatting to that column so that the
records in Jan can change to green colour by using the formula
=MID(A2,4,3)="Jan". However, it doesn't work! Please kindly advise what's
wrong with the formula and how to solve my problem.

Thanks in advance

Conditional Formatting
 

Freshman

That's because the data in the cell is not text but a number (1 is Jan 1st
1900) masked by a format.

You can use

=MONTH(A2)=1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Freshman" wrote in message
...
Dear experts,

I've a column in date format "dd/mmm/yy", such as:

08-Jan-07
12-Feb-07
21-Jan-07
18-Mar-07

When I want to apply conditional formatting to that column so that the
records in Jan can change to green colour by using the formula
=MID(A2,4,3)="Jan". However, it doesn't work! Please kindly advise what's
wrong with the formula and how to solve my problem.

Thanks in advance

Conditional Formatting
 

Hi Nick,

Thanks for your tips and it is working well now. Thanks again.

"Nick Hodge" wrote:

Freshman

That's because the data in the cell is not text but a number (1 is Jan 1st
1900) masked by a format.

You can use

=MONTH(A2)=1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Freshman" wrote in message
...
Dear experts,

I've a column in date format "dd/mmm/yy", such as:

08-Jan-07
12-Feb-07
21-Jan-07
18-Mar-07

When I want to apply conditional formatting to that column so that the
records in Jan can change to green colour by using the formula
=MID(A2,4,3)="Jan". However, it doesn't work! Please kindly advise what's
wrong with the formula and how to solve my problem.

Thanks in advance

Conditional Formatting
 

Great

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Freshman" wrote in message
...
Hi Nick,

Thanks for your tips and it is working well now. Thanks again.

"Nick Hodge" wrote:

Freshman

That's because the data in the cell is not text but a number (1 is Jan
1st
1900) masked by a format.

You can use

=MONTH(A2)=1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Freshman" wrote in message
...
Dear experts,

I've a column in date format "dd/mmm/yy", such as:

08-Jan-07
12-Feb-07
21-Jan-07
18-Mar-07

When I want to apply conditional formatting to that column so that the
records in Jan can change to green colour by using the formula
=MID(A2,4,3)="Jan". However, it doesn't work! Please kindly advise
what's
wrong with the formula and how to solve my problem.

Thanks in advance