Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
The dimension C was pivoted earlier.
See now.
make sure your values in cells are not nulls.
If you have any nulls, you cannot see the color in that cell(i anticipate.)
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.
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
and how do I set the background color of the desired fields (every second row) then?
If i am not wrong, they are already been colored with lightgray.
just replace the lightgrya() with red() everywhere then you can see red.
I want to highlight the following fields in the table (see attached).
I can not see in any example how to color them.
IS this what you wanted?
see attached.
those are not field values.
as you have pivoted the dimension, its just an empty column.
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.