Hello,
I am working on a Calendar macro. It is just about complete but I have one issue. The end users want specific coloring to the tasks that get brought into the calendar where some words in the cell are colored differently than other words in the same cell. Some tasks are green, some are blue, some are red etc. Conditional formatting isn't an option because one cell may have just a few words red while the rest is black. I have the macro built to pull formulas in that bring over the tasks from a task list tab into the calendar however they come in black. What I want to do in the code now is paste value the calendar that has formulas once the tasks are brought over and then do a match between the tabs. When the match is found go to the task list tab that has the colored text copy it and bring it back into the calendar so that i get the coloring the end users are looking for. Any help will be appreciated.
Bookmarks