Conditional Formatting for every Nth word

Hi everyone,

I need a function or macro (not even sure which one I need) that can:

1) highlight every Nth word in the text in a cell
2) list every Nth word under a column

is this possible in excel or should I look for other solutions?

Thanks in advance.