HighLight Max Value in a row of data

[Former Member]

How can I highlight the max value in each row of data

Month     Col1         Col2           Col3

Jan           12             21               6                          I want to highlight the 21

Feb           9               32             45                          I want to highlight the 45

[abhilash_kumar · Accepted solution]

Hi David,

1) Create a formula with this code and place it anywhere on the Details Section:

shared Numbervar array x := [{Col1},{Col2}, {Col3}];

'';

2) Right-click Col1 > Format Field > Border tab > Click the formula button beside 'Background' and paste this code:

shared Numbervar array x;

if CurrentFieldValue = Maximum(x) then

crYellow

else

crNoColor

3) Highlight Col1 > Double-click the Format Painter icon on the toolbar (It looks like a paint brush) > Apply the brush on Col2 and then on Col3. This should apply the same formatting formula on the other columns as well.

-Abhilash