Conditional Formating
 

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!

Conditional Formating
 

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!

Conditional Formating
 

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!

Conditional Formating
 

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

" wrote:

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!

Conditional Formating
 

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

"FSt1" wrote:

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

" wrote:

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!

Conditional Formating
 

On May 14, 1:56*pm, FSt1 wrote:
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



"FSt1" wrote:
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

" wrote:

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!- Hide quoted text -

- Show quoted text -

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