Table cell Coloring

[Rick M]

wire wizards;

I need to figure out how to apply conditional formatting to a table of measurement

results. In Excel,(am I allow to swear like that in here ;->) conditional formatting

can be applied to table columns or rows such that if the contents of a particular

cell is greater than a value, I can apply one condition (i.e. color the cell GREEN

to indicate a 'PASS' condition), and if the contents of that cell are less than the

same value, I can apply a different condition (i.e. color the same cell RED).

This allows in a quick glance through *alot* of values to find any failing data.

Is this something easily accomplished in LV? (BTW Win2K, LV7.0 PDS)

Thanks in advance

Rick

[David Boyd]

Rick,

Tables in LV are always an array of strings. There's no 'conditional formatting' as such, but the attached VI gives a trivial example of using property nodes on the table to recolor the cells at runtime.

Hope This Helps.

Dave

Download File:post-10-1088696703.vi

[lucas_dili]

Dave:

Do you know if there is a way to hide the column and rows separation in a table???

thank you

Lucas

[nightdweller]

Dave:

Do you know if there is a way to hide the column and rows separation in a table???

thank you

Lucas

1476[/snapback]

Lucas,

By blending your table, and seperator with the same color( ie white) you can hide the seperator.

Vince

[David Boyd]

Dave:

Do you know if there is a way to hide the column and rows separation in a table???

thank you

Lucas

1476[/snapback]

Lucas,

If I understand what you want, I don't think it's quite possible. The 'grid' of lines can be repainted any color you like (through the control editor), but if you've set background colors of cells (using the example I gave you), there will always be a perceptible line between adjacent cells painted different colors. If you change the FOREground colors of cells (meaning the text), and leave all the BACKgrounds the same, and paint the grid the same color as the background, then the grid lines will 'appear to disappear'.

Did that make sense to anyone but me??

Dave

[Jack Kelledes]

I'm fairly new at creating nice interfaces so forgive me if this is too elementary.

I was just trying something like this in LV 6.1 in a table.

The Active Cell cluster in the Property Node uses a cluster that is the Row number and Column number.

Make a property node that has Active Cell and Cell Background Color in it.

Once you know the row of the data that is out of range put that number in for the row and -2 in for the column in the Active Cell cluster and put the new color in the Cell Background Color (I use color box constants because they're easier for me).

To color a column instead of a row, reverse the numbers.

To color a whole table, use -2 in both numbers.

[Mike Ashe]

Hmm, I should have scrolled down to the bottom of this topic before I coded up this example .

Oh well, here is a simple example of using -2 to color alternating rows. Any more is an exercise left to the student...

Cheers :beer:

Download File:post-45-1104431973.vi