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