Conditional Formatting Based on List Column Count 1

[Hanzelmans]

I want to use Conditional Formatting in a Group Footer to highlight a List Column Count when the count exceeds a certain amount.

I don't see any way to use a non-list column item to use in the condition. Is it possible?

Steve Hanzelman
Milton Hershey School

http://www.mhs-pa.org

 

[blom0344]

Please explain why you need a non-list column item..
Yould should be able to use any queryitem, provided you associate this item in the list properties when you do not use it in the list itself..

Ties Blom

 

[Hanzelmans]

Hi Ties,
I can't associate the List Column count with the list because when I go to the List ancestor that does not appear in the Properties for selection.

Am I looking in the right place?

Thanks,
Steve

Steve Hanzelman
Milton Hershey School

http://www.mhs-pa.org

 

[blom0344]

Hmm, Say you have grouped a list on a dataitem and then added a count on one of the columns, it will not add a new dataitem to the query.
Suppose your dataitem is [bigwig] from [query1] then it should suffice to create a boolean variable that reads :
[query1].[bigwig] > 10. Set this variable as a style variable on the group footer and add a conditional format for the 'yes' part.

Ties Blom

 

[Hanzelmans]

Ties,
Bingo! That worked.

I hadn't looked at performing it that way. I was concentrating on just being able to choose a data item and using the Conditional Styles Tool.

Steve

Steve Hanzelman
Milton Hershey School

http://www.mhs-pa.org