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 · Accepted solution]

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",....... ))

[Odiez]

Thank you, working now

[jaichith]

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

This will work perfectly