Conditional Formatting

F

Freshman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top