View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Freshman Freshman is offline
external usenet poster
 
Posts: 158
Default 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