Conditinal Formatting
 

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,