Date value conditional formatting or Macro
 

Hello The cell value is 00Y - 07M which is a date formatted as yy "Y" -
mm "M". This column has over 1,000 numbers. What I want to do is if the
first three values = E.g. 00Y - 07M then show only the last values or
07M otherwise it should remain the same Thanks