|
excel設定格式化條件
哪個版本的excel,其*定*式化條件數 可以不限3個
|
excel設定格式化條件
"kevin" wrote:
哪個版本的excel,其*定*式化條件數 可以不限3個 Which edition does excel, its decide formatted item to be allowed not to limit 3 Pl post in English. For conditional formatting, until excel 2003 (my current ver) the limit is still 3 conditions. I don't have/know about excel 2007. If you have more than 3 conditions to format, check out these 2 options: 1. JE McGimpsey's page at: http://www.mcgimpsey.com/excel/conditional6.html Getting 6 conditional font colors without macros The page also contains links to Dave McRitchie's & Chip Pearson's CF pages 2. Bob Phillips' page at: http://xldynamic.com/source/xld.CFPlus.Download.html -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| All times are GMT +1. The time now is 03:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com