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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting in Excel 2007 1
Conditional formatting on a dynamic range - workaround 1
Conditional Formatting 4
Conditional Cell Formatting 5
Conditional Formatting 3
Unable to obtain relative reference using conditional formatting 2
conditional formatting for tab color 2
Apply Conditional Formatting to other rows 6

Top