S
Saintsman
VL L M H VH
VH 0 0 0 0 0
H 0 1 0 3 0
M 0 2 4 6 0
L 0 20 3 6 0
VL 0 2 2 1 0
I have a x-tab populating a popup form measuring frequency occurences (VL=
very low; H=high; L=low etc). Grid is always same size & coloured cells are
not dependant on cell contents
Can I shade the boxes according to position in grid
col1 = orange;
col 2 rows 1 - 2 = orange
col 2 rows 3 - 5 = green
col 3 rows 1 - 2 = green
col 3 rows 3 - 5 = orange
etc
col 5 row 5 - red
Basically a 5 x 5 grid with varying colours
VH 0 0 0 0 0
H 0 1 0 3 0
M 0 2 4 6 0
L 0 20 3 6 0
VL 0 2 2 1 0
I have a x-tab populating a popup form measuring frequency occurences (VL=
very low; H=high; L=low etc). Grid is always same size & coloured cells are
not dependant on cell contents
Can I shade the boxes according to position in grid
col1 = orange;
col 2 rows 1 - 2 = orange
col 2 rows 3 - 5 = green
col 3 rows 1 - 2 = green
col 3 rows 3 - 5 = orange
etc
col 5 row 5 - red
Basically a 5 x 5 grid with varying colours