Forum Discussion
Solved
How can I sort values and color of data from highest to lowest.
Hi, I want to sort values and color of data from highest to lowest. I am trying to write the formula: =INDEX(SORT(FILTER(B3:F19,C3:C19>=LARGE(C3:C19,17),""),2,-1),SEQUENCE(17),{1,2,4,5}) I...
- I didn't/couldn't open the sheet in google docs but those bars sure look like conditional formatting and therefor will not appear on the new columns unless you add a new conditional formatting rule. Highlight one of the output columns go into conditional formatting and add a rule for color based on value and use data bars as the type or select the existing conditional formatting for column B and 'duplicate rule' and then change the 'applied to' range to the new range.
I didn't/couldn't open the sheet in google docs but those bars sure look like conditional formatting and therefor will not appear on the new columns unless you add a new conditional formatting rule. Highlight one of the output columns go into conditional formatting and add a rule for color based on value and use data bars as the type or select the existing conditional formatting for column B and 'duplicate rule' and then change the 'applied to' range to the new range.
