Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.... |
#2
|
|||
|
|||
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.... |
#3
|
|||
|
|||
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.... |
#4
|
|||
|
|||
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.... |
#5
|
|||
|
|||
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.... |
#6
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
identify even numbers with a "1" and odd numbers with a "0" | Excel Worksheet Functions | |||
search to identify duplicate enties in long columns of numbers | Excel Discussion (Misc queries) | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
identify numbers which are listed in two columns. | Excel Worksheet Functions | |||
Identify missing record numbers | Excel Discussion (Misc queries) |