Conditional formatting between worksheets

R

Reinhart

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
 
B

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)
 
R

Reinhart

Perfect, it works.

Thanks guys...

Bob Phillips said:
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)
Click to expand...
 
Top