Conditional formatting between worksheets

[Guest]

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

 

[Bob Phillips]

Another way is to use a defined name for the cell being referenced, and use
the name in the CF.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Perfect, it works.

Thanks guys...

Another way is to use a defined name for the cell being referenced, and use
the name in the CF.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)