Colour fields

  • Thread starter Thread starter Saintsman
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top