You may not use references to other worksheets or workbooks forConditional Formatting criteria.

[Lynn]

i have copied my worksheet to another workbook. while trying to
perform conditional formatting i got this error:

You may not use references to other worksheets or workbooks for
Conditional Formatting criteria.

how to fix this?

 

[Ron Rosenfeld]

i have copied my worksheet to another workbook. while trying to
perform conditional formatting i got this error:

You may not use references to other worksheets or workbooks for
Conditional Formatting criteria.

how to fix this?

Please do not multi-post. See response in .misc
--ron

 

[Ron Rosenfeld]

i have copied my worksheet to another workbook. while trying to
perform conditional formatting i got this error:

You may not use references to other worksheets or workbooks for
Conditional Formatting criteria.

how to fix this?

That should read: see response in microsoft.public.excel
--ron