Conditional Formating

  • Thread starter Thread starter summerloman
  • Start date Start date
S

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!
 
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
 
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!
 
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
 
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
 
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 -
Click to expand...

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