Issue with Conditional Formatting

[Georgetown15x]

Dear All,

I am total dummy with no programming background, your insights or solutions for the question below is highly appreciated.

First, I have a table called -  movement

Name (Type=Text)	Notes (Type=Text)	Online (Type= Yes/No)
ABC	Desk	Online
XYZ	Rest	Offline

What I am trying to do is make the rectangle fill colour change to black when is Offline.

So I've put in the function below in the rectangle's fill column

If(ThisItem.IsSelected, RGBA(0,0,0,0.1), If(ThisItem.Online="Offline",Black,RGBA(0,0,0,0)))

And it seems the function is not right...Could someone please help? Thanks.

[GarethPrisk · Accepted solution]

You mentioned Online was a Yes/No, or Boolean field - correct?

If(ThisItem.IsSelected, RGBA(0,0,0,0.1), If(ThisItem.Online,Black,RGBA(0,0,0,0)))

If the field is a Yes/No (Boolean, with a True/False as its actual value), then you can check it explicitly.

[Georgetown15x]

You are Legend!