Colour fields

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
 
D

Dale Fye

You could try conditional formatting using an expression based on the value
in your row header.

In my test, I opened a form that was formatted as a datasheet, selected one
of the "columns", then chose Format->Conditional Formatting.

In Condition1, I selected the "Expression Is" option and in the textbox to
the right entered:

[Numbers] IN (3, 7, 9)

Then I set the forground and background colors accordingly

In your case, I think you would highlight the textbox associated with your
VL label and just set the backcolor to orange. Then, select the textbox
associated with your "L" column label, and under conditional formatting enter
something like:

Default Formatting:
Set the default background for this column to green

Condition 1:
Expression Is: [RowFieldName] IN ("VH", "H")
then set the backcolor to orange

HTH
Dale
 
Top