AnsweredAssumed Answered

Conditional Formatting on Repeating Field

Question asked by LambdaEnt on Feb 20, 2014
Latest reply on Aug 16, 2016 by David Moyer


Conditional Formatting on Repeating Field


     I have a repeating calculation (number) field with 7 repetitions in a table (Timesheet::Daily Total), and a single number field in another table (Insured::Budget).

     Using conditional formatting, I want any one of the Daily Total repetitions to display red when that repetition exceeds the value in Budget (but not all repetitions, only the one that exceeds).

     Conditional Format on Timesheet::Daily Total
Value isgreater than Insured::Budget

     It doesn't work.

     If I set Value isless than, ALL repetitions turn red no matter what the value of Timesheet::Daily Total.