Skip to main content
Question

Using multiple colors based on checkbox

  • April 23, 2022
  • 0 replies
  • 40 views

I'm trying to use a different color based on whether a checkbox is checked.

case([Standards],true,"#5E9DFF",([LOA]),true,"#F54400")
 It gives me an "Expected text but got bool" error.  I don't need both to be true, just if [Standards] is checked then one color or if [LOA] is checked then another color.
Thoughts?

I can get one color to work, but not able to add the other.


------------------------------
Tony Miller
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

try this


IF(
[Standards],"#5E9DFF",
[LOA],"#F54400")



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------