Identify Numbers
 

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)
FormatConditional Formatting and use the drop down to select Formula Is
In the white pane enter
=ISNUMBER(FIND("4606050005",$F2))

--
Regards
Roger Govier
"Mandeep Dhami" wrote in message
...
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 <atyahoo<dotcom
----
"Mandeep Dhami" wrote in message
...
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)
FormatConditional Formatting and use the drop down to select Formula Is
In the white pane enter
=ISNUMBER(FIND("4606050005",$F2))

--
Regards
Roger Govier
"Mandeep Dhami" wrote in message
...
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 <atyahoo<dotcom
----
"Mandeep Dhami" wrote in message
...
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 <atyahoo<dotcom
----
"Mandeep Dhami" wrote in message
...
Thanks a lot Max, it is exactly what I wanted and anticipated.