conditional formatting

[greg]

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

 

[Frank Kabel]

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

 

[greg]

thanks for the suggestions. i will give it a try