Conditional Formating

[summerloman]

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!

 

[FSt1]

hi
select O2 then on the menu bar....format>conditional 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

 

[summerloman]

Wow, thanks. That did the trick! Would you mind explaining, if you
can, what the formula means so that I may learn to use this function
and apply it to other spreadsheets?

I understand that the search is for the word "LEED" and that we are
searching in cell C2. But was does the 1 mean after C2, and then the
1 and 0 at the end?

Thanks again!

 

[FSt1]

hi
the basic formula is a true/false set up
=if(condition),true,false) or 1 for true, 0 for false
the search part has 3 parts
search term(LEED)
search text(text in C2 or just C2)
Start point. i put 1 meaning start from the first character of the text(in c2)
The true/false setup in O is looking at C and determining if the condition
is true(1) or false(0).
so....
search c2 for LEED, start at character 1 and if true(1)then color else if
false(0), don't.
=if(search("LEED", C2,1),1,0)

regards
FSt1

 

[FSt1]

afterthought...
you can sub the word true for 1 and false for 0 in the formula with no
difference in out come. i use 1 and 0 because it less typing and shorter
formula.

regards
FSt1

 

[summerloman]

afterthought...
you can sub the word true for 1 and false for 0 in the formula with no
difference in out come. i use 1 and 0 because it less typing and shorter
formula.

regards
FSt1





- Show quoted text -

Thanks! That helps me make a LOT more sense of it all. I appreciate
your time!