Formula-Colour text listed in rows under particular coloured words

[TH1234]

I am using Office 2016 - Excel on a Mac
I have a very large spreadsheet, so I need a formula that will do this for me.
The example below shows the basic layout of info.
There is info in columns A to G but it is irrelevant for this exercise. (Its to all remain black font)
I want to change the text colour to blue for those words listed in column H and their corresponding value in column I (not listed below). But only for the text that is between the blue font and red font.
The result would be that the words Zombie and Cherry below would end up being blue font and nothing else altered.

eg
heading of column H = Allocated to
Row 1 blank. (There is a blank row between each 'group' of info)
Row 2 "Home" (this is in black font)
Row 3 "Edible" (this is in black font)
Row 4 Allocated not cut (this is in blue font and underlined)
Row 5 "Zombie" (this is in black font)
Row 6 "Cherry". (this is in black font)
Row 7 "Not Allocated:" (this is in red font)

I am new here, so I hope I have explained this enough for you to understand.

Cheers T

[FDibbins]

Hi, welcome to the forum

If you want to highlight a specific word within a text string, you will need VBA for that, formulas cannot do that.

If the cell will only contain 1 word (or string of words) that you want (everything) to change color, you could probably use Conditional Formatting for that.

For more specific suggestions,

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.