In a table, change color of the row, when the status is different

[Giovanni1]

I would like the rows of a table to color automatically, without selecting the single rowtaking the color from an sql tables. This is the function I use to pick the color, in the select fill ColorValue(LookUp('[dbo].[USR_TIPI]';DESCRIZIONE=DataTable6.Selected.TIPOVISITA And NEGOZIO=DataTable3.Selected.CODICENEGOZIO ;HEXCOLOR)) Thank's in advance

[zmorek]

If I understand correctly, you want each row of the gallery to have a different color, without having to be selected first? Use the TemplateFill() property. 

[KvB1]

I am assuming that @Giovanni1 is using a DataTable control. I couldn't find any property that regulates the fill of rows, but I dont have any experience with DataTables.

In a Gallery this will definately be possible.

[zmorek]

@KvB1 Ah, my apologies, I must have missed that/misread

[Giovanni1]

Yes, but not in a gallery, bat in a table