hi
select O2 then on the menu bar....formatconditional forant....
formula is....=IF(SEARCH("LEED",C2,1),1,0).....pick your format.

Copy O2 then copy down column O.

the search formula is seaching C2 for LEED. if found, high like O2 else don't.

Regards
FSt1

" wrote:

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!