Background color cell

[Anonymous]

Hi guys,

Is it possible to fix my background color?

Sometimes I have the same color in cells, because it skips cells without data.

Please see my files.

regards,

[MK_QSL]

Go to Style and select and style..

Also select Stripes every 1 rows

[Anonymous]

Nothing changed

[#4]

Actually qv skips the format for empty cells.

Setting the presentation panel without "Supress Zero Values" and with "Populate Missing Cells" helps a little but, in many cases, doesn't solve the problem.

I usually create zero values in script or use NumSum(Sum(...)) in the chart expressions so you always have data in every cells.

Regards,

Fernando

[maxgro]

I think Manish is right; why you say nothing changed?

comment your background color expression, follow Manish post, .....

or I'm missing someting?

[chiru_thota]

Hi ,

I could see a condition on expression background color and it is the reason

If(Even(RowNo()), rgb(220,220,220), rgb(238,233,233))

By fixing it you can get rid of the cell color.

Thanks,

Chiru

[Anonymous]

Please see my screen shot

[maxgro]

please see attachment

regards

[MK_QSL]

You need to remove background color expression under both dimensions and expression

[Anonymous]

I resolved it. Thanks, But I'd like make colours of cells a bit darker.

Because brightness of my computer is high and I couldn't see them.