assign background color in edit script window

[Anonymous]

can we assign background color in the edit script apart from the dimensions box

[andrey_krylov]

Hi Sunny. It can be done using a variable.

In the edit script:            vDim1Color = 'If(Dim1 = 'A', Green(), Red())';

In the dimension box:     $(vDim1Color)

[jobsonkjoseph]

Yes it is possible, if you have the RGB values.

[juraj_misina]

Hi,

I've done something like this a few times. Assuming my dimension is [Country]:

Country_Colors:
LOAD * inline [
Country, R, G, B
USA, 255, 0, 0
Germnay, 0, 255, 0
France, 0, 0, 255
];

Then in background color expression I used

RGB(Only(), Only(), Only())

[Anonymous]

Thanks for the reply Andrey,

is there possibility to change background color if cell value is changed/updated