| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting: Excel 2003 vs. 2007
Excel 2003 does not allow references to other worksheets for Conditional
Formatting criteria. Does Excel 2007? Thank you, JP. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting: Excel 2003 vs. 2007
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting: Excel 2003 vs. 2007
Thank you Roger and best regards,
JP "Roger Govier" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting: Excel 2003 vs. 2007
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) "Roger Govier" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Conditional Formatting barely works | Excel Discussion (Misc queries) | |||
| How do I display all conditional formatting in Excel? | Excel Worksheet Functions | |||
| Why do conditional formats appear by themselves in Excel 2003? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel: Additional Conditional Formatting | Excel Worksheet Functions | |||
Hybrid Mode
