Forum Discussion
Color code based on table data
Hi - I have a table of data feeding information to a calendar on another sheet. One column in the table is 'Content type'. I am trying to use conditional formatting so that the calendar is color code...
Not possible outside of VBA.
I'm NOT a VBA expert, but I think you're looking for something like this: https://answers.microsoft.com/en-us/msoffice/forum/all/automatically-coloring-partial-text-within-cell-in/1ae89408-3874-46a6-9c68-5983f1b29b96
I'm NOT a VBA expert, but I think you're looking for something like this: https://answers.microsoft.com/en-us/msoffice/forum/all/automatically-coloring-partial-text-within-cell-in/1ae89408-3874-46a6-9c68-5983f1b29b96