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

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?

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

On Sat, 18 Jul 2009 06:48:14 -0700 (PDT), Lynn wrote:

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

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

On Sat, 18 Jul 2009 06:48:14 -0700 (PDT), Lynn wrote:

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