how to add another conditional formatting
 

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

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"kapenabowl" wrote in message
...
In Excel, I know that I can do 3 conditional formatting. How do I add a
4th
one?