Tricky: Conditional Formatting based of Matrix Elements

[rippchen10247]

Hey there,

i have a 5x5 matrix table consisting of some correlation values. The values are not unique, so some of them are mentioned once (e.g. 0), some twice (e.g. 0.1), some even more often (e.g. 0.2).

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]0.2
[/TD]
[TD]0.4
[/TD]
[TD]0.6
[/TD]
[TD]0.8
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]0.15
[/TD]
[TD]0.3
[/TD]
[TD]0.45
[/TD]
[TD]0.6
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]0.1
[/TD]
[TD]0.2
[/TD]
[TD]0.3
[/TD]
[TD]0.4
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]0.0
[/TD]
[TD]0.1
[/TD]
[TD]0.15
[/TD]
[TD]0.2
[/TD]
[/TR]
</tbody>[/TABLE]

What I want to do is to apply conditional formatting always only to one matrix element, no matter, if the value is mentioned once, twice or more often than this..

E.g.: I want to do conditional formatting for the element which is defined by the row 2 & and column 4 element, thus 0.4 should be highlighted through conditional formatting there, but only there and not for the same element which is stated in row 1 column 2.

The whole stuff should be dynamic for rows and columns, so that I can target all single matrix elements for my conditional formatting based on what I chose as row and column.

Thought of =offset =index(,match, match), but was not successful so far

Can someone help me to create an elegant formula?

 

[gior]

Variant of formula for conditional formatting in Cell C4

=(MOD(ROW()+4,7)=OFFSET(C4, -MOD(ROW()+4,7), 3-MOD(COLUMN()-1,7))) * (MOD(COLUMN()-2,7)=OFFSET(C4, -MOD(ROW()+4,7), 5-MOD(COLUMN()-1,7)))