Background Color Pivot chart (if one dimension on top)

[richters]

Hi all,

I created a pivot chart and want to highlight every second row. So I gave every formula and dimension a background formula as followed:

=if(mod(rowno(),2)=0,LightGray(80))

Is it possible to give the cells in red a background color?

Thanks a lot!

[krishna_2644]

The dimension C was pivoted earlier.

See now.

[krishna_2644]

make sure your values in cells are not nulls.

If you have any nulls, you cannot see the color in that cell(i anticipate.)

[richters]

Look at my example, I got a dimension on top and want to color the complete row. My problem are the cells of the dimension which is on the top.

[krishna_2644]

thats what i said.

When you pivot the dimension, you cannot use rowno().

just specify the background color or text color with no condition on rowno().

See attached

[richters]

and how do I set the background color of the desired fields (every second row) then?

[krishna_2644]

If i am not wrong, they are already been colored with lightgray.

just replace the lightgrya() with red() everywhere then you can see red.

[richters]

I want to highlight the following fields in the table (see attached).

I can not see in any example how to color them.

[krishna_2644]

IS this what you wanted?

see attached.

[krishna_2644]

those are not field values.

as you have pivoted the dimension, its just an empty column.

[richters]

No, I totally know how to change the color. But in the first red row (Station=B) - the second column (under the dimension title of the second dimension) the field is not red. I want it to be red.