Hey all,

I want the format of a cell in worksheet 1 depending on a value of a cell in
worksheet 2 without copying the value of this cell to worksheet 1. The excel
functionality does not allow this. How can I work around it?

Example:
Formule Is: ='Mechelen-SMaarten-Upgrade 543'!$B$12 ="X"
Example of format if condition is true: Lime color

Thanks,

Rein