Forum Discussion

Davy's avatar
Davy
Contributor
3 years ago

Why is 1S not formating pink (which is returned by u8#formula) ?

Hi, I have a u8#memberformula that I am trying to use for the first time - to format the background color of a cell. I know that setting  BackgroundColor = pink will cause the cell to turn pi...
Finance
Cosimo's avatar
Cosimo
Contributor II
3 years ago

Davy,

I don't think you can use a member name or GetDatacell to return the value "pink". What I would do is use a dashboard parameter example: BackgroundColor = |!GetBackgrounColor!| and then set the color name within the literal parameter. If the color changes based on data value, you can call an XFBR rule within the dashboard parameter, have the rule analyze the value for current cell POV and return the appropriate color code. I haven't tried the latter so not 100% sure it works but I do think it's possible.