Hi gurus,
in my list report i have a calculated column which has YES, NO values. now i want to display all the 'YES' records in a color.
how can i do this???
thanks in adv
Hi everleaner:
You would use the conditional styles icon on the tool bar.
Loum
im not sure, but i think the "normal" conditional style (button in the menu bar) will enable conditional formating for numbers?!
what will work for sure is creating a bool variable (variable panel), and use a syntax like [Data Item] = 'Yes' .
Then, use this variable as style variable in the property pane of your data container (list/ crosstab).
in the last step, you want to click on the "yes" (or "no") in the property panel of your nbew created variable, the panel will become green and you wil be able to format the columns/ rows or even cells as pleased.
cheerz :P
You can use conditional formatting for anything, not just numbers. I tend to select Advanced Conditional Style and then use any expression that suits my fancy. I find conditional style easier than style variables, but I suppose it is just a matter of preference. Either approach works.