software

I have a matrix similar to below. I'd like for those amounts that agree to be
shaded and those that do not, to not be shaded. For example, everything in
the table would be shaded except for b:c / c:b. Any suggestions?

X A B C
A 0 2 1
B 2 0 2
C 1 3 0Select your range (say A14)
and with A1 the activecell
format|conditional formatting
formula is:
=COUNTIF($A$1:$D$4,A1)gt;1

And give it a nice pattern.

Corey wrote:
gt;
gt; I have a matrix similar to below. I'd like for those amounts that agree to be
gt; shaded and those that do not, to not be shaded. For example, everything in
gt; the table would be shaded except for b:c / c:b. Any suggestions?
gt;
gt; X A B C
gt; A 0 2 1
gt; B 2 0 2
gt; C 1 3 0

--

Dave Peterson

This kind of works for the most part. It seems to search for any match, not
the ones at the corresponding vector points. For instance, the formula also
highlights the 2 in the third column. ??

quot;Dave Petersonquot; wrote:

gt; Select your range (say A14)
gt; and with A1 the activecell
gt; format|conditional formatting
gt; formula is:
gt; =COUNTIF($A$1:$D$4,A1)gt;1
gt;
gt; And give it a nice pattern.
gt;
gt; Corey wrote:
gt; gt;
gt; gt; I have a matrix similar to below. I'd like for those amounts that agree to be
gt; gt; shaded and those that do not, to not be shaded. For example, everything in
gt; gt; the table would be shaded except for b:c / c:b. Any suggestions?
gt; gt;
gt; gt; X A B C
gt; gt; A 0 2 1
gt; gt; B 2 0 2
gt; gt; C 1 3 0
gt;
gt; --
gt;
gt; Dave Peterson
gt;

The 2 in the third column matched the 2 elsewhere.

I guess I didn't understand the question.

Corey wrote:
gt;
gt; This kind of works for the most part. It seems to search for any match, not
gt; the ones at the corresponding vector points. For instance, the formula also
gt; highlights the 2 in the third column. ??
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Select your range (say A14)
gt; gt; and with A1 the activecell
gt; gt; format|conditional formatting
gt; gt; formula is:
gt; gt; =COUNTIF($A$1:$D$4,A1)gt;1
gt; gt;
gt; gt; And give it a nice pattern.
gt; gt;
gt; gt; Corey wrote:
gt; gt; gt;
gt; gt; gt; I have a matrix similar to below. I'd like for those amounts that agree to be
gt; gt; gt; shaded and those that do not, to not be shaded. For example, everything in
gt; gt; gt; the table would be shaded except for b:c / c:b. Any suggestions?
gt; gt; gt;
gt; gt; gt; X A B C
gt; gt; gt; A 0 2 1
gt; gt; gt; B 2 0 2
gt; gt; gt; C 1 3 0
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

The matrix reads as a relationship to corresponding criteria.

Does row C, column B = column B, row C (inverse of each other)

Only two intersections are being compared here. I'm thinking it might have
to be done manually.

quot;Dave Petersonquot; wrote:

gt; The 2 in the third column matched the 2 elsewhere.
gt;
gt; I guess I didn't understand the question.
gt;
gt; Corey wrote:
gt; gt;
gt; gt; This kind of works for the most part. It seems to search for any match, not
gt; gt; the ones at the corresponding vector points. For instance, the formula also
gt; gt; highlights the 2 in the third column. ??
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Select your range (say A14)
gt; gt; gt; and with A1 the activecell
gt; gt; gt; format|conditional formatting
gt; gt; gt; formula is:
gt; gt; gt; =COUNTIF($A$1:$D$4,A1)gt;1
gt; gt; gt;
gt; gt; gt; And give it a nice pattern.
gt; gt; gt;
gt; gt; gt; Corey wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I have a matrix similar to below. I'd like for those amounts that agree to be
gt; gt; gt; gt; shaded and those that do not, to not be shaded. For example, everything in
gt; gt; gt; gt; the table would be shaded except for b:c / c:b. Any suggestions?
gt; gt; gt; gt;
gt; gt; gt; gt; X A B C
gt; gt; gt; gt; A 0 2 1
gt; gt; gt; gt; B 2 0 2
gt; gt; gt; gt; C 1 3 0
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Maybe you could use =index() and invert the columns and rows.

But I think you'd have to specify more info--well at least for me to attempt it.

The address the table is located and a few examples of which cells to check.

Corey wrote:
gt;
gt; The matrix reads as a relationship to corresponding criteria.
gt;
gt; Does row C, column B = column B, row C (inverse of each other)
gt;
gt; Only two intersections are being compared here. I'm thinking it might have
gt; to be done manually.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; The 2 in the third column matched the 2 elsewhere.
gt; gt;
gt; gt; I guess I didn't understand the question.
gt; gt;
gt; gt; Corey wrote:
gt; gt; gt;
gt; gt; gt; This kind of works for the most part. It seems to search for any match, not
gt; gt; gt; the ones at the corresponding vector points. For instance, the formula also
gt; gt; gt; highlights the 2 in the third column. ??
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Select your range (say A14)
gt; gt; gt; gt; and with A1 the activecell
gt; gt; gt; gt; format|conditional formatting
gt; gt; gt; gt; formula is:
gt; gt; gt; gt; =COUNTIF($A$1:$D$4,A1)gt;1
gt; gt; gt; gt;
gt; gt; gt; gt; And give it a nice pattern.
gt; gt; gt; gt;
gt; gt; gt; gt; Corey wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have a matrix similar to below. I'd like for those amounts that agree to be
gt; gt; gt; gt; gt; shaded and those that do not, to not be shaded. For example, everything in
gt; gt; gt; gt; gt; the table would be shaded except for b:c / c:b. Any suggestions?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; X A B C
gt; gt; gt; gt; gt; A 0 2 1
gt; gt; gt; gt; gt; B 2 0 2
gt; gt; gt; gt; gt; C 1 3 0
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Assuming your matrix at A1 is named array1
=INDEX(array1,ROW(),COLUMN())=INDEX(array1,COLUMN( ),ROW())I'm not sure I understand. I went ahead and name A1 to 'array1'. I then put
your formula in the conditional formatting step. Nothing happened. ??

quot;Herbert Seidenbergquot; wrote:

gt; Assuming your matrix at A1 is named array1
gt; =INDEX(array1,ROW(),COLUMN())=INDEX(array1,COLUMN( ),ROW())
gt;
gt;

Move the matrix so A1 is the upper left cell of the matrix.
Then select all the cells in the matrix and name the matrix array1.
Use Insert gt; Name gt; Define
or don't use a name and say $A$1:$D$4 instead.
If your matrix is located anyplace else on the spreadsheet, use
=INDEX(array1,ROW()-ROW(array1) 1,COLUMN()-COLUMN(array1) 1)=
INDEX(array1,COLUMN()-COLUMN(array1) 1,ROW()-ROW(array1) 1)Thanks!!! This worked great!!

quot;Herbert Seidenbergquot; wrote:

gt; Move the matrix so A1 is the upper left cell of the matrix.
gt; Then select all the cells in the matrix and name the matrix array1.
gt; Use Insert gt; Name gt; Define
gt; or don't use a name and say $A$1:$D$4 instead.
gt; If your matrix is located anyplace else on the spreadsheet, use
gt; =INDEX(array1,ROW()-ROW(array1) 1,COLUMN()-COLUMN(array1) 1)=
gt; INDEX(array1,COLUMN()-COLUMN(array1) 1,ROW()-ROW(array1) 1)
gt;
gt;