Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top