Highlighting row based on a certain criteria
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much, it worked perfectly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
