Condition for format rule not working

[Odiez]

In Appshett I am trying to do the following

I have a few names and want to make one column Red for all of them, but I cannot get it to work
Condition for format rule (Inligitn) Mei 2023-4

1 [Naam] = “Centus”,“Centus Plus”, “Bincome”,“Binc”,“Dbc”,“bincua”
(The value of column ‘Naam’) is equal to (“Centus”)

[jaichith]

Please share screen shot for this particular formatting.

[Odiez]

Here is he screenshots

[jaichith]

Use OR () function

Example

OR(
[CONSIGNMENTS STATUS]=“RETURN RECEIVED” ,
[CONSIGNMENTS STATUS]=“RETURN INITIATED”
)

[Odiez]

Not working, what am I doing wrong

[jaichith]

Wrap the or () for the entire expression.

Or(

[Naam] = “centre” , [Naam] = " venture plus", …

)

You can try this also

In([Naam] , list (“centus”, centus plus",… ))

[jaichith]

In( [Naam] , list( “Centus”,“Centus Plus”, “Bincome”,“Binc”,“Dbc”,“bincua”)

This will work perfectly

[Odiez]

Thank you, working now