Identify Numbers

[Guest]

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

 

[Roger Govier]

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

 

[Max]

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

 

[Guest]

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

 

[Guest]

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

 

[Max]

You're welcome, Mandeep !