Color Matching of Cells?

[Guest]

Hi there,

Does anyone know if it is possible to link cells through colour fill? I want
to be able to have information appear in different cell locations depending
on the color of the fill of the input cell.

So basically if I fill a cell with information with a yellow shading, I want
that particular piece of information to appear in a certain cell. Then if I
shaded that cell in another color, then it would appear in a different
location.

If this is possible could someone please advise me.

Thank you very much in advance,

A Kruse

 

[Guest]

Very easy. If you just select the background color of a cell, its very hard
for another cell to detect it. But it is easy if conditional formatting is
used.

Let's say we want:
the data in B1 to appear in C1 if the background color of B1 is green
the data in B1 to appear in C2 if the background color of B1 is yellow
the data in B1 to appear in C3 if the background color of B1 is red

In cell A1 enter one of the following words:
green
yellow
red

Set the conditional format of cell B1 to Formula Is:
=a1="green" and make the background green
=a1="yellow" and make the background yellow
=a1="red" and make the background red

So now you can change the background color of B1 just by changing the value
in A1.

Enter:
=B1
in C1 thru C3 (the same formula in each, NOT copy/paste). At this point the
same value appears in C1 thru C3

In C1, also using conditional formatting, set the font color the same as the
background color if a1 equals either red or yellow.

In C2, also using conditional formatting, set the font color the same as the
background color if a1 equals either red or green.

In C1, also using conditional formatting, set the font color the same as the
background color if a1 equals either green or yellow.

Now if you examine C1 thru C3, only one of them will apear to have the value
in B1, the other two will appear empty because the font has the same color as
the background.