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....