Prev: Doing a countif against a substring of the range to be scanned
Next: how do I create independent results?
From: tech1NJ on 29 Mar 2010 13:45
I have 2 sheets with infomation. Sheet1 C2:C15000 have some text in each
cell. Some cells in C2:C15000 have the same text, or may have slightly
different text. Sheet2 E3 has a free text cell that my end users can type
into it at will. I like to turn the Cells C2:C15000 in Sheet1 to turn yellow
if the keyword in E3 is found within the text in C2:C15000 on Sheet1.
--
tech1NJ
From: Nadine on 29 Mar 2010 14:35
Put your cursor into Sheet 1 Cs. Go to Conditional Formula, and choose is
equal to and then move to the next box and type in =$E3. The choose Format
and choose yellow on the Patterns tab. Copy and paste this all the way down
to C15000.
Nadine

"tech1NJ" wrote:

> I have 2 sheets with infomation. Sheet1 C2:C15000 have some text in each
> cell. Some cells in C2:C15000 have the same text, or may have slightly
> different text. Sheet2 E3 has a free text cell that my end users can type
> into it at will. I like to turn the Cells C2:C15000 in Sheet1 to turn yellow
> if the keyword in E3 is found within the text in C2:C15000 on Sheet1.
> --
> tech1NJ
From: tech1NJ on 29 Mar 2010 15:34
Tried that. I does not work as Sheet2 E3 is part of the text that is found in
the cells in Sheet1 C2:C15000. This almost would need to have a formula that
would first see the free text entered in Sheet2 E3, perform the search in
Sheet1 C2:C15000, then perform the conditional formating to be yellow. Do you
agree....

See example below of what I have.

Sheet1 C2:C4 - shorten the number of cells for the example sake
C2= Has the build up to date
C3 = The build can be out of range
C4= All up to date nothing else to do at this time

Sheet2 E3 - free text entered by user is "build" (without the quotes).

I need Excel to search C2:C4 find the ones with "build: and perform the
conditional formatting to equal yellow.
--
tech1NJ


"Nadine" wrote:

> Put your cursor into Sheet 1 Cs. Go to Conditional Formula, and choose is
> equal to and then move to the next box and type in =$E3. The choose Format
> and choose yellow on the Patterns tab. Copy and paste this all the way down
> to C15000.
> Nadine
>
> "tech1NJ" wrote:
>
> > I have 2 sheets with infomation. Sheet1 C2:C15000 have some text in each
> > cell. Some cells in C2:C15000 have the same text, or may have slightly
> > different text. Sheet2 E3 has a free text cell that my end users can type
> > into it at will. I like to turn the Cells C2:C15000 in Sheet1 to turn yellow
> > if the keyword in E3 is found within the text in C2:C15000 on Sheet1.
> > --
> > tech1NJ
From: Nadine on 29 Mar 2010 16:24
I think I've got it. Put your cursor in Sheet 2 Cell E3. Name the cell by
going to the upper left of your screen until you see a white box with E3 and
a drop down arrow. Click inside the white box and name the cell - maybe call
it UserEntry or something that makes sense to you without the spaces. Hit
enter.

Now go to Sheet 1 and try it again but where you say what it should be equal
to, type in =UserEntry or whatever you called cell E3. Continue with the
conditional formatting.

Hope that works.

Nadine

"tech1NJ" wrote:

> Tried that. I does not work as Sheet2 E3 is part of the text that is found in
> the cells in Sheet1 C2:C15000. This almost would need to have a formula that
> would first see the free text entered in Sheet2 E3, perform the search in
> Sheet1 C2:C15000, then perform the conditional formating to be yellow. Do you
> agree....
>
> See example below of what I have.
>
> Sheet1 C2:C4 - shorten the number of cells for the example sake
> C2= Has the build up to date
> C3 = The build can be out of range
> C4= All up to date nothing else to do at this time
>
> Sheet2 E3 - free text entered by user is "build" (without the quotes).
>
> I need Excel to search C2:C4 find the ones with "build: and perform the
> conditional formatting to equal yellow.
> --
> tech1NJ
>
>
> "Nadine" wrote:
>
> > Put your cursor into Sheet 1 Cs. Go to Conditional Formula, and choose is
> > equal to and then move to the next box and type in =$E3. The choose Format
> > and choose yellow on the Patterns tab. Copy and paste this all the way down
> > to C15000.
> > Nadine
> >
> > "tech1NJ" wrote:
> >
> > > I have 2 sheets with infomation. Sheet1 C2:C15000 have some text in each
> > > cell. Some cells in C2:C15000 have the same text, or may have slightly
> > > different text. Sheet2 E3 has a free text cell that my end users can type
> > > into it at will. I like to turn the Cells C2:C15000 in Sheet1 to turn yellow
> > > if the keyword in E3 is found within the text in C2:C15000 on Sheet1.
> > > --
> > > tech1NJ
From: Nadine on 29 Mar 2010 16:26
Disregard. I should have tested before sending. I'll keep trying to find a
solution.

"Nadine" wrote:

> I think I've got it. Put your cursor in Sheet 2 Cell E3. Name the cell by
> going to the upper left of your screen until you see a white box with E3 and
> a drop down arrow. Click inside the white box and name the cell - maybe call
> it UserEntry or something that makes sense to you without the spaces. Hit
> enter.
>
> Now go to Sheet 1 and try it again but where you say what it should be equal
> to, type in =UserEntry or whatever you called cell E3. Continue with the
> conditional formatting.
>
> Hope that works.
>
> Nadine
>
> "tech1NJ" wrote:
>
> > Tried that. I does not work as Sheet2 E3 is part of the text that is found in
> > the cells in Sheet1 C2:C15000. This almost would need to have a formula that
> > would first see the free text entered in Sheet2 E3, perform the search in
> > Sheet1 C2:C15000, then perform the conditional formating to be yellow. Do you
> > agree....
> >
> > See example below of what I have.
> >
> > Sheet1 C2:C4 - shorten the number of cells for the example sake
> > C2= Has the build up to date
> > C3 = The build can be out of range
> > C4= All up to date nothing else to do at this time
> >
> > Sheet2 E3 - free text entered by user is "build" (without the quotes).
> >
> > I need Excel to search C2:C4 find the ones with "build: and perform the
> > conditional formatting to equal yellow.
> > --
> > tech1NJ
> >
> >
> > "Nadine" wrote:
> >
> > > Put your cursor into Sheet 1 Cs. Go to Conditional Formula, and choose is
> > > equal to and then move to the next box and type in =$E3. The choose Format
> > > and choose yellow on the Patterns tab. Copy and paste this all the way down
> > > to C15000.
> > > Nadine
> > >
> > > "tech1NJ" wrote:
> > >
> > > > I have 2 sheets with infomation. Sheet1 C2:C15000 have some text in each
> > > > cell. Some cells in C2:C15000 have the same text, or may have slightly
> > > > different text. Sheet2 E3 has a free text cell that my end users can type
> > > > into it at will. I like to turn the Cells C2:C15000 in Sheet1 to turn yellow
> > > > if the keyword in E3 is found within the text in C2:C15000 on Sheet1.
> > > > --
> > > > tech1NJ
 |  Next  |  Last
Pages: 1 2
Prev: Doing a countif against a substring of the range to be scanned
Next: how do I create independent results?