Identify Numbers:Conditional formating

Mark the whole range of your data (excluding your header row)
Format>Conditional Formatting and use the drop down to select Formula Is
In the white pane enter
=ISNUMBER(FIND("4606050005",$F2))

--
Regards
Roger Govier
"Mandeep Dhami" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a database in six columns, the sixth coulmn has some alphanumeric
> data.
> I want a conditional formating such that by identifying the specific
> numbers
> in the data of sixth coulmn the whole row should change to a certain
> colour
> so as the user to pay special attention while using that data.
>
> The alphanumeric data is like this:
> Contract Number 4606050005 closed on 13/06/05
> Project closed on 13/06/05, use 4606050005
> 4606050005 use unless informed otherwise
>
> I want in whichever row of the 6th column has "4606050005" this number the
> whole row should change to a different colour.
>
> Thanks in anticipation....

Try this ..

Assume the 6 cols are cols A to F, 6th col = col F

Select say, rows 1 to 10 (select the row headers)

Click Format > Conditional Formatting

Under Condition 1, make the settings as:
Formula is| =ISNUMBER(SEARCH(4606050005,$F1))

Click Format button > Patterns tab > Green? > OK
Click OK at the main dialog

Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Mandeep Dhami" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a database in six columns, the sixth coulmn has some alphanumeric
data.
> I want a conditional formating such that by identifying the specific
numbers
> in the data of sixth coulmn the whole row should change to a certain
colour
> so as the user to pay special attention while using that data.
>
> The alphanumeric data is like this:
> Contract Number 4606050005 closed on 13/06/05
> Project closed on 13/06/05, use 4606050005
> 4606050005 use unless informed otherwise
>
> I want in whichever row of the 6th column has "4606050005" this number the
> whole row should change to a different colour.
>
> Thanks in anticipation....

Thanks a lot Roger, it is exactly what I wanted and anticipated.

"Roger Govier" wrote:

> Mark the whole range of your data (excluding your header row)
> Format>Conditional Formatting and use the drop down to select Formula Is
> In the white pane enter
> =ISNUMBER(FIND("4606050005",$F2))
>
> --
> Regards
> Roger Govier
> "Mandeep Dhami" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I have a database in six columns, the sixth coulmn has some alphanumeric
> > data.
> > I want a conditional formating such that by identifying the specific
> > numbers
> > in the data of sixth coulmn the whole row should change to a certain
> > colour
> > so as the user to pay special attention while using that data.
> >
> > The alphanumeric data is like this:
> > Contract Number 4606050005 closed on 13/06/05
> > Project closed on 13/06/05, use 4606050005
> > 4606050005 use unless informed otherwise
> >
> > I want in whichever row of the 6th column has "4606050005" this number the
> > whole row should change to a different colour.
> >
> > Thanks in anticipation....
>
>
>

Thanks a lot Max, it is exactly what I wanted and anticipated.

"Max" wrote:

> Try this ..
>
> Assume the 6 cols are cols A to F, 6th col = col F
>
> Select say, rows 1 to 10 (select the row headers)
>
> Click Format > Conditional Formatting
>
> Under Condition 1, make the settings as:
> Formula is| =ISNUMBER(SEARCH(4606050005,$F1))
>
> Click Format button > Patterns tab > Green? > OK
> Click OK at the main dialog
>
> Adapt to suit ..
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Mandeep Dhami" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I have a database in six columns, the sixth coulmn has some alphanumeric
> data.
> > I want a conditional formating such that by identifying the specific
> numbers
> > in the data of sixth coulmn the whole row should change to a certain
> colour
> > so as the user to pay special attention while using that data.
> >
> > The alphanumeric data is like this:
> > Contract Number 4606050005 closed on 13/06/05
> > Project closed on 13/06/05, use 4606050005
> > 4606050005 use unless informed otherwise
> >
> > I want in whichever row of the 6th column has "4606050005" this number the
> > whole row should change to a different colour.
> >
> > Thanks in anticipation....
>
>
>

You're welcome, Mandeep !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Mandeep Dhami" <[email protected]> wrote in message
news:[email protected]...
> Thanks a lot Max, it is exactly what I wanted and anticipated.

Hi,

I have a database in six columns, the sixth coulmn has some alphanumeric data.
I want a conditional formating such that by identifying the specific numbers
in the data of sixth coulmn the whole row should change to a certain colour
so as the user to pay special attention while using that data.

The alphanumeric data is like this:
Contract Number 4606050005 closed on 13/06/05
Project closed on 13/06/05, use 4606050005
4606050005 use unless informed otherwise

I want in whichever row of the 6th column has "4606050005" this number the
whole row should change to a different colour.

Thanks in anticipation....

Mark the whole range of your data (excluding your header row)
Format>Conditional Formatting and use the drop down to select Formula Is
In the white pane enter
=ISNUMBER(FIND("4606050005",$F2))

--
Regards
Roger Govier
"Mandeep Dhami" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a database in six columns, the sixth coulmn has some alphanumeric
> data.
> I want a conditional formating such that by identifying the specific
> numbers
> in the data of sixth coulmn the whole row should change to a certain
> colour
> so as the user to pay special attention while using that data.
>
> The alphanumeric data is like this:
> Contract Number 4606050005 closed on 13/06/05
> Project closed on 13/06/05, use 4606050005
> 4606050005 use unless informed otherwise
>
> I want in whichever row of the 6th column has "4606050005" this number the
> whole row should change to a different colour.
>
> Thanks in anticipation....

Try this ..

Assume the 6 cols are cols A to F, 6th col = col F

Select say, rows 1 to 10 (select the row headers)

Click Format > Conditional Formatting

Under Condition 1, make the settings as:
Formula is| =ISNUMBER(SEARCH(4606050005,$F1))

Click Format button > Patterns tab > Green? > OK
Click OK at the main dialog

Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Mandeep Dhami" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a database in six columns, the sixth coulmn has some alphanumeric
data.
> I want a conditional formating such that by identifying the specific
numbers
> in the data of sixth coulmn the whole row should change to a certain
colour
> so as the user to pay special attention while using that data.
>
> The alphanumeric data is like this:
> Contract Number 4606050005 closed on 13/06/05
> Project closed on 13/06/05, use 4606050005
> 4606050005 use unless informed otherwise
>
> I want in whichever row of the 6th column has "4606050005" this number the
> whole row should change to a different colour.
>
> Thanks in anticipation....

Thanks a lot Roger, it is exactly what I wanted and anticipated.

"Roger Govier" wrote:

> Mark the whole range of your data (excluding your header row)
> Format>Conditional Formatting and use the drop down to select Formula Is
> In the white pane enter
> =ISNUMBER(FIND("4606050005",$F2))
>
> --
> Regards
> Roger Govier
> "Mandeep Dhami" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I have a database in six columns, the sixth coulmn has some alphanumeric
> > data.
> > I want a conditional formating such that by identifying the specific
> > numbers
> > in the data of sixth coulmn the whole row should change to a certain
> > colour
> > so as the user to pay special attention while using that data.
> >
> > The alphanumeric data is like this:
> > Contract Number 4606050005 closed on 13/06/05
> > Project closed on 13/06/05, use 4606050005
> > 4606050005 use unless informed otherwise
> >
> > I want in whichever row of the 6th column has "4606050005" this number the
> > whole row should change to a different colour.
> >
> > Thanks in anticipation....
>
>
>

Thanks a lot Max, it is exactly what I wanted and anticipated.

"Max" wrote:

> Try this ..
>
> Assume the 6 cols are cols A to F, 6th col = col F
>
> Select say, rows 1 to 10 (select the row headers)
>
> Click Format > Conditional Formatting
>
> Under Condition 1, make the settings as:
> Formula is| =ISNUMBER(SEARCH(4606050005,$F1))
>
> Click Format button > Patterns tab > Green? > OK
> Click OK at the main dialog
>
> Adapt to suit ..
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Mandeep Dhami" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I have a database in six columns, the sixth coulmn has some alphanumeric
> data.
> > I want a conditional formating such that by identifying the specific
> numbers
> > in the data of sixth coulmn the whole row should change to a certain
> colour
> > so as the user to pay special attention while using that data.
> >
> > The alphanumeric data is like this:
> > Contract Number 4606050005 closed on 13/06/05
> > Project closed on 13/06/05, use 4606050005
> > 4606050005 use unless informed otherwise
> >
> > I want in whichever row of the 6th column has "4606050005" this number the
> > whole row should change to a different colour.
> >
> > Thanks in anticipation....
>
>
>

You're welcome, Mandeep !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Mandeep Dhami" <[email protected]> wrote in message
news:[email protected]...
> Thanks a lot Max, it is exactly what I wanted and anticipated.