Color code based on table data

%3CLINGO-SUB%20id%3D%22lingo-sub-2835166%22%20slang%3D%22en-US%22%3EColor%20code%20based%20on%20table%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2835166%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20have%20a%20table%20of%20data%20feeding%20information%20to%20a%20calendar%20on%20another%20sheet.%20One%20column%20in%20the%20table%20is%20'Content%20type'.%20I%20am%20trying%20to%20use%20conditional%20formatting%20so%20that%20the%20calendar%20is%20color%20coded%20bsaed%20on%20content%20type.%20For%20example%2C%20anything%20listed%20as%20'website'%20content%20type%20shows%20up%20as%20blue%20on%20the%20calendar%20(etiher%20via%20cell%20fill%20or%20text%20color)%20and%20anything%20listed%20as%20'video'%20shows%20up%20as%20orange%20on%20the%20calendar%2C%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20set%20this%20up%3F%20I%20am%20open%20to%20other%20suggestions%20if%20conditional%20formatting%20is%20not%20the%20best%20option.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2835166%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2835730%22%20slang%3D%22en-US%22%3ERe%3A%20Color%20code%20based%20on%20table%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2835730%22%20slang%3D%22en-US%22%3ENot%20possible%20outside%20of%20VBA.%3CBR%20%2F%3EI'm%20NOT%20a%20VBA%20expert%2C%20but%20I%20think%20you're%20looking%20for%20something%20like%20this%3A%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fautomatically-coloring-partial-text-within-cell-in%2F1ae89408-3874-46a6-9c68-5983f1b29b96%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fautomatically-coloring-partial-text-within-cell-in%2F1ae89408-3874-46a6-9c68-5983f1b29b96%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

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 coded bsaed on content type. For example, anything listed as 'website' content type shows up as blue on the calendar (etiher via cell fill or text color) and anything listed as 'video' shows up as orange on the calendar, etc. 

 

Can someone help me set this up? I am open to other suggestions if conditional formatting is not the best option. 

1 Reply
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-ce...