List box have limitations on conditional formatting.
- Create field in your load statement: weekday(date(makedate(year, month, day), 'YYYY-MM-DD')) AS YourWeek
- Create a straight table, use YourWeek as a dimension, click on the + sign to the left and add conditional format statement like if(YourWeek > 5, red()) in the editor when you double click on 'Text Color'
- In the expression: sum(1). In the presentation, hide the column sum(1).
The disadvantage is that you will loose the horizontal alignment.
Dinesh is right and we dont have conditional formatting for list box. But you can achieve this by doing some workarounds. Attached is the example using Dinesh's approach.
List box formatting.qvw 126.0 K