conditional format ref., diff work sheet
 

How do i set up conditional format using different worksheet.
exp.
=not('worksheet2'b6=0)

conditional format ref., diff work sheet
 

CF cannot cross from one worksheet to another
On the worksheet where the CF is needed find a blank, out of the way cell,
and use =Worksheet2!B6
In the CF setting, reference the cell with this formula
Experiment and see if the column or row with the formula can be hidden - I
cannot recall
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"djc" wrote in message
...
How do i set up conditional format using different worksheet.
exp.
=not('worksheet2'b6=0)

conditional format ref., diff work sheet
 

djc wrote:
How do i set up conditional format using different worksheet.
exp.
=not('worksheet2'b6=0)


Select B6 in worksheet2 and give it a name (like "worksheet2B6"). Then
reference that name in the conditional format.