how to add another conditional formatting

K

kapenabowl

In Excel, I know that I can do 3 conditional formatting. How do I add a 4th
one?
 
M

Max

Inclusive of the default fill color, its actually 4 conditions !

Anyway .. you may wish to check out:
a. Bob Phillips' CFPlus - Extended Conditional Formatter
add-in at:
http://www.xldynamic.com/source/xld.CFPlus.Download.html
(Bob's write-up there states that up to *30* cond formats are catered for
...)

b. 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
 
Top