Forum Discussion
pennylolabird
Jun 14, 2021Copper Contributor
gradient bars color change within a cell
I inherited a worksheet and have been asked to change the color of a gradient bar WITHIN a cell. It is very hard to explain as I have never seen this before. I am attaching a screenshot of here it. There are actually two places that I need to change the color. How do I access this??
This one works
= LET( commission, Allocateλ(+salesAmount,Bands, Rate), SUM(commission))
The difference is in +salesAmount . Auto-lifting not always works.
2 Replies
Sort By
You may play with conditional formatting Use conditional formatting to highlight information - Excel (microsoft.com)
- pennylolabirdCopper ContributorGot it! Thanks!