Conditional Formatting Portal from another Portal

[npgdan]

How do I conditional farmat a portal row based off matching fields in another portal?

I have created a table for employees with thier schedule for next 3 weeks. A global table so I may have two incidents of the same table filtered by global fields. This way I can display two employees schedules side by side using one table.

 

So Table1 with Store Number, Employee Name, Work Date, Start Time, End Time. 

Table2 Store Number, Trainer Name(Global), Traniee Name(Global).

Related field 

Table1::Store Number to Table2::Store Number.

Table1 Copy::Store Number to Table2::Store Number

 

Layout based on Table2

Two Portals Portal 1 (Table1) Portal 2 (Table1 Copy)

Portal 1 is filtered by Table1::Employee Name = Table2::Trainer Name

Portal 2 is filtered by Table1 Copy::Employee Name = Table2::Trainee Name

 

This works fine, I am able to display Trainer schedule next to Trainee Schedule.

 

What I would like to do is add conditional formating to Portal 2 Start Date Field by comparing the same date from Portal 1 when Portal 1 Start Time is between Portal 2 Start and End Time.

 

I tried this formula in conditioanl formatting 

 

(Table1 Copy::Work Date = Table1::Work Date and Table1::Start Time > Table1 Copy::Start Time and Table1::Start Time < Table1 Copy::End Time)

 

This works only for the first portal row. It does not evalualte the 15 other rows in the portal. Is there a way evaluate portal rows that match date and the additioanl conditions throughout the complete portal?

 

Thank you for you assistance..

 

Dan