Format Rules in Enum list

[Julio_Moyano]

Hi,

I have a Enum type column [state order] with 3 alternative: ‘Open’, ‘Cancel’ and ‘Complete’

I would like to make a format rules where if is ‘Open’ put green in ‘Id number’, if is ‘Cancel’ put red and so on. then when state order change change the color too.

I have tried IN(‘Open’, order[state order]) in format rules, but it is not working well

thanks!

[Marc_Dillon · Accepted solution]

[state order] = "Open"