Referencing list of numbers below , I would like to highlight the 9 values closest to 0. If done manually, it would be -5,1,2,3, 4, 5, 6, 7, 8. What formula can I use as a row rule in basic table? I'm using basic table to highlight the background color for visibility. Thanks
-500
-200
-100
-50
-10
-5
0
1
2
3
4
5
6
7
8
Solved! Go to Solution.
Hey @yxt
I think you would need to do some pre-work before the basic table to create a flag to say these are the rows you want to highlight
@LordNeilLord is correct.
I'd built something like the attached to identify the values I'm interested in and create a column with a flag. You can then use the flag to define the column rule
Hi @yxt
I have a few questions
Can you explain what you mean by "closest to zero"? In your sample data -500 is not closer to 0 than any of the positive values, yet you include it in your list to flag.
Do you always require 9 values to be highlighted?
What if you have more than 9 negative numbers?
Dan
@danilangthanks for questioning. I've incorrectly phrased my question. Let me edit my post.
the 9 closes value to 0 would be -5, 1,2,3,4,5,6,7,8
Hi @MichalM . I've been pointed out that my post was incorrect. Otherwise it would be the perfect solution.
Corrected my post to mean : If done manually, it would be -5,1,2,3, 4, 5, 6, 7, 8.
this was such a straightforward solution. thank you so much!