Hi JP

No there is no change for XL2007 (as far as I can see)
As with XL2003, you can get around it by naming the cell on another
sheet, then setting the CF to
=test=1
where test = Sheet2!C5 for example

--
Regards

Roger Govier


"JP" wrote in message
...
Excel 2003 does not allow references to other worksheets for
Conditional Formatting criteria. Does Excel 2007? Thank you, JP.