Formating a entire column on Matrix

[Chance1234]

I have my data which is like the following;

Client, Title, Dayname, Day, bCount

ABC, Chase clients, Monday, 1, 1
Null,Null, Tuesday, 2, 0
Null,Null, Wednesday, 3, 0
ABC, Finalise Cilent, Thursday, 4, 1

etc etc etc

I then have a matrix control

In then have as my rows

Client, Title

As my columns

Day, Name of Day

And Bcount for my data area.

I have some formating in place already , on the background which is like the following


=IIf(Fields!bCount.Value>0,"Blue","White")

So for all my days where there is an event, they are shaded blue.

I now, for aesthetics want that if the column = Saturday or Sunday that the entire column is greyed.

Chance,

F, G + 1MSTG

 

[xlbo]

RS is hierarchically dependant

Cell formatting overrules row / column formatting which overrules table formatting. If you already have cell formatting then you will need to add a condition to your formula

=IIf(Fields!Dayname.Value = "Saturday" or Fields!Dayname.Value = "Sunday","Grey",iif("Fields!bCount.Value>0,"Blue","White"))

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Chance1234]

That seems to only do my first row,

Chance,

F, G + 1MSTG

 

[xlbo]

What did you apply it to?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Chance1234]

tried it on both cell and column,

Chance,

F, G + 1MSTG

 

[xlbo]

Can you give me an idea of the graphical layout of the matrix? Do your "blue & white" colours work on all rows?

Have you got any other formatting applied - to either cells / rows / columns or groups?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Chance1234]

Im using a query very similiar to the one discused in this thread

thread183-1463239

So a list of dates
events happening on the dates


Then my layout is

Title in the column
Days going across the top
and the data field is bcount

Chance,

F, G + 1MSTG

 

[xlbo]

weird

you havn't put the values in a header row have you? (check by hovering the mouse over the left side of the table - like where row numbers are in excel)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question