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?