Is it possible to add colour to a table box column?

[josephinetedesc]

Hi all

I have a datasheet table box and I want to highlight the blank cells.  Is this possible?

I was wondering if I can use the Number sheet:  It is not obvious that I can.

I want to use the Table Box rather than a pivot table or a Straight table because I want to see the blanks as I want to show how the Statistic Box is working.  For example the Statistic Box will count all PIDs but the Pivot Table will not count the PIDs if the field cell is blank.  Probably once I am used to why some boxes show a certain number and other boxes don't I can stop using the Table Box.

Jo

Jo

[lironbaram · Accepted solution]

hi

you can't color data in table box ,

you can use the number to define the format of the field .

you can mimic table box with straight table by adding all the fields as dimension

and a dummy expression like write 1 in the expression box.

then you'll be able to color the data

[josephinetedesc]

Thank you

I forgot about that!

Jo