Excel Conditional Formatting

[Guest]

I am trying to create conditional formating for my worksheet.
cell(row,column)
If the value in For n= 1, end of active rows (cell(n,1) and cell(n,3) and
cell(n,4)) =
For i=n+1, end of active rows (cell(i,1) and cell(i,3) and cell(i,4) )
Then cell(n,5) = cell(i,5) or cell(i,5) = cell(n,5)

If there is a missing for cell(n,5) or cell(i,5) then fill in the missing
value.
Or if cell(n,5) <> cell(i,5) highlight both cells in red.

From the example listed below in the third row and column 5 the value should
be fill
in with the value of Dallas.

Listed below in the second and fourth row and column 5 both cells should
highlighted in red.

Example:
Column1 Column3 Column4 Column5
1 10/1/07 34 Dallas
6 3/4/07 23 Chicago
1 10/1/07 34
6 3/4/07 23 Denver


Please help me create condtional formatting for the example listed above.

Thank You,

 

[Bob Phillips]

Select all the D cells starting in D1 and use a CF formula of

=AND(COUNTIF($A$1:A1,A1)>1,COUNTIF($B$1:B1,B1)>1,COUNTIF($C$1:C1,C1)>1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)