Conditional Formatting: Excel 2003 vs. 2007

J

JP

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

Roger Govier

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
 
J

JP

Thank you Roger and best regards,
JP

Roger Govier said:
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
Click to expand...
 
C

Chip Pearson

You'd think that with all the changes they made to CF, they would have fixed
this shortcoming. Maybe next time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
Top