| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Macro Conditional Formatting | Excel Worksheet Functions | |||
| Conditional Formatting in a Macro | Excel Discussion (Misc queries) | |||
| Conditional Formatting in Macro | Excel Discussion (Misc queries) | |||
| How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions | |||
Linear Mode
