Highlighting row based on a certain criteria

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.

output.xlsx

Input.xlsx

Accepted answers

vizAlter

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.

Highlight highest two.yxmd

All comments

randreag

hi @SCK

You could use the table from report tools

check the workflow

I hope it helps

Answer.yxmd

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?

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 ?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703