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

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)

"Max" wrote in message
...
One way is to use INDIRECT with an incrementer, eg ROW(A1) ..

Assume you want the CF to trigger in col B in say, Sheet1, if
corresponding
cells in col B in the source sheet: Mechelen-SMaarten-Upgrade 543 contain:
"X"

In Sheet1,

Select col B (B1 active), then apply the cond format formula:
=INDIRECT("'Mechelen-SMaarten-Upgrade 543'!B"&ROW(A1))="X"
Format as desired. The CF will trigger as required. If B2, B20, B100 in
the
source sheet contain: "X", then B2, B20, B100 in Sheet1 will be
conditionally
formatted. Adapt to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Reinhart" wrote:
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

Perfect, it works.

Thanks guys...

"Bob Phillips" wrote:

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)

"Max" wrote in message
...
One way is to use INDIRECT with an incrementer, eg ROW(A1) ..

Assume you want the CF to trigger in col B in say, Sheet1, if
corresponding
cells in col B in the source sheet: Mechelen-SMaarten-Upgrade 543 contain:
"X"

In Sheet1,

Select col B (B1 active), then apply the cond format formula:
=INDIRECT("'Mechelen-SMaarten-Upgrade 543'!B"&ROW(A1))="X"
Format as desired. The CF will trigger as required. If B2, B20, B100 in
the
source sheet contain: "X", then B2, B20, B100 in Sheet1 will be
conditionally
formatted. Adapt to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Reinhart" wrote:
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