austenr
09-02-2015, 01:43 PM
I'm sure this can be done but have no idea where to start.
Lets say say in workbook A you have a cell with the format. jan-15 and so on for the rest of the year.
Workbook B you have a column with names in this case column A and there are headers for every month, like jan-15, feb-15, etc.
main workbook B, there is formatting let's say it's green that spans a row next to a persons name and the cells jan thru may are colored green. This means that the person has that span of time to get a task completed.
On Workbook A, the month mar-15 is selected. I need the colored formatting that exists for jan thru may cleared and moved to the next year beginning in mar-16 for 5 months signifying the person has 5 months from mar-16 to complete the task next year.
It it may be confusing and I can upload workbooks if someone can help me out. I know I probably need a formula for conditional formatting if not rules and for sure need a worksheet change event Thanks for any input and I can post workbooks if anyone can help.
Lets say say in workbook A you have a cell with the format. jan-15 and so on for the rest of the year.
Workbook B you have a column with names in this case column A and there are headers for every month, like jan-15, feb-15, etc.
main workbook B, there is formatting let's say it's green that spans a row next to a persons name and the cells jan thru may are colored green. This means that the person has that span of time to get a task completed.
On Workbook A, the month mar-15 is selected. I need the colored formatting that exists for jan thru may cleared and moved to the next year beginning in mar-16 for 5 months signifying the person has 5 months from mar-16 to complete the task next year.
It it may be confusing and I can upload workbooks if someone can help me out. I know I probably need a formula for conditional formatting if not rules and for sure need a worksheet change event Thanks for any input and I can post workbooks if anyone can help.