AnsweredAssumed Answered

Highlight lowest value

Question asked by AAgraphics on Apr 13, 2012
Latest reply on Apr 13, 2012 by philmodjunk


Highlight lowest value


FMP 11 on Mac and PC

We have a table where 96 fields are times

The fields are TIME01 , TIME02 , TIME03 . . . . TIME96

The times are broken into sets of 16 with each set receiving one of eight titles

The set names are AOKE , BOKE , COKE, DOKE . . . . HOKE

The layout lists all 96 fields for all records and the titles for each set

How can you use conditional formatting to highlight the lowest time across all records for TIME04 when the sets have the same title?