Conditional formatting based on several conditions

Hi,

I am trying to do some conditional formatting to highlight rows based on several conditions, I don't know if this is possible, but these are the criteria:

AAPL	tt	10/1/2013 11:14:15
GOOG	ll	10/1/2013 11:14:20
AAPL	ff	10/1/2013 11:14:31
AAPL	rr	10/2/2013 14:52:30

I want to highlight a row if:
- the difference in time value is < 20 seconds
- the first symbol column is the same
- at least one, but not all of the rows meeting the above criteria contains a value in the second column from a given list (in this example, say tt is on this list)

So if done properly the logic would highlight the first and third rows, but would highlight none if none of the values in column two match my list.

I think the test criteria would go something like this, however I know that there are problems with my row references.

=and(abs($C2-$C3:$C65536)<0.0003,$A2=$A3,match($A2,Sheet1!A:A,0)>0)


Please let me know if this is clear or you would like more details.

Thanks,

T

Hi,
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.



View Pic