Hi,

Basicly I want to give a cell in a sheet the same background color as the cell in another sheet. But it should also adjust itself when the other cell's background changes. The other cell gets it's layout by conditional formatting, and I found something (also with conditional formatting) so I can give the cells in the other sheet the same value. Problem is I cannot do this for many cells at once because I do it like this:
Please Login or Register  to view this content.
for every cell. The cell beneath it would get the rule:
Please Login or Register  to view this content.
Thus checking if the cell in the other sheet is the biggest of R3:R10. Now I have to add a rule for every cell and *** there are many cells that need to change I wondered if there wasn't an easier solution.

In the original sheet I could just use one rule for all cells for checking if the cell had the biggest value:
Please Login or Register  to view this content.
I cannot use the CELL EQUALS anymore because it is not the cell itself but the cell in the other sheet that should be the biggest value.

Sorry if I was confusing, but thanks for reading

WitteThee