Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating based on Date
Okay, I have been working with this for some time, but no I have a problem.
I am pulling data from a standard document. The date format from this document is: JAN 15, 2009 It cannot be changed by using the date format, and with this format the Conditional Formating will not function. One column is set to color 01 Oct 07 through 30 Sep 08 and 01 Oct 08 through 30 Sep 09. The rest of the document is coded to color the current month, and the next two individually. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating based on Date
=--(MID(A2,5,2)&" "&LEFT(A2,3)&" "&RIGHT(A2,4)) will work if you've always
got 2 digits for the day of the month. =--(MID(A2,5,LEN(A2)-10)&" "&LEFT(A2,3)&" "&RIGHT(A2,4)) if there might be 1 or 2 digits. In each case, format the result cells as an appropriate date format. -- David Biddulph "Flcnmech" wrote in message ... Okay, I have been working with this for some time, but no I have a problem. I am pulling data from a standard document. The date format from this document is: JAN 15, 2009 It cannot be changed by using the date format, and with this format the Conditional Formating will not function. One column is set to color 01 Oct 07 through 30 Sep 08 and 01 Oct 08 through 30 Sep 09. The rest of the document is coded to color the current month, and the next two individually. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating based on a different cell | Excel Discussion (Misc queries) | |||
Conditional Formating Based on Date | Excel Discussion (Misc queries) | |||
Conditional formating based on text | Excel Worksheet Functions | |||
Set conditional formating for cell based on value in different cel | Excel Discussion (Misc queries) | |||
Conditional Formating based on another cell | Excel Discussion (Misc queries) |