I tried conditional formatting..but it doesn't seem to work.
In my worksheet there is a field that allow users to select a color by changing the color of a cell.
What i want is, a different cell to change it's color corresponding to that cell.
Example: if A1 is red B2 must also be red. But...