How can I do this?
If it is impossible it should be a feature request for sure.
I disagree. Conditional formatting can be set on individual buttons in a 'bar' (I have a solution that uses these). However, "state" (as with other objects conditionally set) is NOT respected. What I mean: if you have an object set with a conditional (many variations), then Hover, for example, is no longer functioning.
And that's why we have:
You are correct, that setting (initially) different values for fill/icon on each button in a bar seems to not be possible.
Setting the text (by text formatting calculation), in the button itself may be an option.
please define: "multiple colors"
Do you mean: gradient?
Button1: Red fill, White text
Button2: Blue fill, Green text
Button3: Yellow fill, Red text
and so on...
Conditional formatting seems to only work on the entire button bar as well so no help there.
Having a lot of issues with trying to push the uses of button bars today.
A couple of days ago I watched a RCConsulting video showing a clever way to do this. I couldn't find the link but they could point you to it.
That's the one. You're good!
I know how to google 'richard carlton video button' ?
beverly I did get conditional formatting to work for my use and the other states are not needed in my case. Thank you.
Retrieving data ...