Conditional Formatting

[Guest]

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

 

[Nick Hodge]

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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

 

[Guest]

Hi Nick,

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

 

[Nick Hodge]

Great

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