View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default 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