Is there a way that I can get a cell to turn, say red, if another cell
in that row has a certain word within it? For example:

Column 'C' contains what kind of information was sent to me, some of
which is LEED information about a product. So the cell will say
something of this sort: LEED submittals - concrete. Every one is a
different submittal however and will say something different.

I'm just wondering if there is some way through conditional
formatting, or otherwise that would allow me to highlight a cell in
column 'O' if the cell in column 'C' of that row contains the word
"LEED"

Thanks!