Locate-select records with both ColA & ColC filled

Hello forum,

I am currently editing a road name index worksheet to use as a reference index in a book. This table has 3 columns as follows..

road name 1	neighbourhood name 1	page number1
road name 2	neighbourhood name 2	page number2
-	-	page number3

----
this has 6ooo records in it....I am trying to locate-select the records in Column C that do not have a Column A cell filled in (or more easily has both colA & colB filled cell). I am doing that in order to continue with a sort by column A to have the final look of the table.

would a sort by column A do the trick I am looking for in order to discard unwanted data afterwards?would the sort be affected by empty cells in Column B?

regards

You'd want to highlight rows that have either ColA or ColB as blank. Hence use in conditional formatting for C2

=IF(OR(A2="",B2=""),TRUE)

and so on

ok...

i manually select the row I am interested in (c22) and then..

I use condition 1 to find if there are blanks in Col A OR B (by using your formula above)

=IF(OR(A22="";B22="").TRUE)

and highlight the particular cells


but an error returns highlighting ,TRUE)

You would need to use the formula (given above) in the 'use formula to determine which cells to format' under 'conditonal formatting'

You need to use the 'Forumla Is' option in Excle 2003 and then use the above formula

Some help on this at
http://office.microsoft.com/en-us/ex...001111661.aspx