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" <(E-Mail Removed)> schrieb im Newsbeitrag
news:#(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>