Hello, i have a question on conditional formatting.
I am using Excel 2003.
if i try to use a condition that references another worksheet, it gives an
error.
"you may not use references to other worksheets or workbooks for conditional
formatting criteria"
why do they do that?
is the only thing i can do is create a bunch of hidden cells to my other
worksheet ("=<other sheet!<other cell")
then reference thoes hidden cells on my condition?
if i can do this, why can't i just go straight to the other sheet?

thanks

Hi
you can define a name for the other cells and use this defined name
('Insert - Name - Define') in the conditional format dialog

--
Regards
Frank Kabel
Frankfurt, Germany

"greg" schrieb im Newsbeitrag
...
Hello, i have a question on conditional formatting.
I am using Excel 2003.
if i try to use a condition that references another worksheet, it
gives an
error.
"you may not use references to other worksheets or workbooks for
conditional
formatting criteria"
why do they do that?
is the only thing i can do is create a bunch of hidden cells to my
other
worksheet ("=<other sheet!<other cell")
then reference thoes hidden cells on my condition?
if i can do this, why can't i just go straight to the other sheet?

thanks

thanks for the suggestions. i will give it a try


"greg" wrote in message
...
Hello, i have a question on conditional formatting.
I am using Excel 2003.
if i try to use a condition that references another worksheet, it gives an
error.
"you may not use references to other worksheets or workbooks for
conditional
formatting criteria"
why do they do that?
is the only thing i can do is create a bunch of hidden cells to my other
worksheet ("=<other sheet!<other cell")
then reference thoes hidden cells on my condition?
if i can do this, why can't i just go straight to the other sheet?

thanks