Highlighting row based on a certain criteria

[SCK]

Hi all. I have been trying to build a workflow and need your help please. Apologies of similar question has been posted. But, would please need help. I am trying to highlight 2 highest data. I have attached the input and output file for your reference. 

[randreag]

hi @SCK 

You could use the table from report tools 

check the workflow

I hope it helps

[SCK]

Thanks for providing a solution, however, imagine a situation with over 10,000 rows and we are unaware of the highest value. In situation like these,we cannot determine the threshold for conditional formatting. How to proceed in such cases?

[vizAlter · Accepted solution]

Hi @SCK — Hope the attached workflow will be helpful.

You can highlight two rows for highest marks even if you get less or more rows (data) or Marks.

[SCK]

Thank you so much, it worked perfectly.

[alijalil]

Hi @randreag @vizAlter , I used the Join tool to merge files and I want to colour code the rows in the Left results. After linking it with the Basic Table tool, the color code shows up on the Browse tool however when I output it to excel, the formatting is lost. Even though I selected the Preserve Formatting box in the Output tool. Can you pls help ?

[leonhekkert]

Hi alijalil,

how do you output back to Excel? If you haven't, try the Render tool from the reporting tool palette. 

As far as I know the preserve formatting box in the output tool is to preserve formatting that is already present in the Excel file.

I'm curious if this will solve your problem.

[alijalil]

Thanks @leonhekkert for the response. 

I tried the render tool now - it worked. When I output using the render tool, the column headers repeat after every row. How can I change setting to only have one column header at the top of the table?