"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
---