My eyes usually struggle with discerning more than 3 colours when it comes to
applying CF <g. But you might want to check out Bob Phillips' CFPlus -
Extended Conditional Formatter:
http://www.xldynamic.com/source/xld.....Download.html

Believe it can handle, to quote ..:
Multiple Conditional Formats, up to 30 in total for any range of cells
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"brian" wrote:
Excel menu allows me to conditionally colour formate a selected range, based
on cell values, up to 3 conditions - i.e. a choice of only 3 colours. Can I
colour formate cells that have value in steps of ten (1-10, 11-20,
.......81-90 and 91-100) using VBA? This is my preferred choice. If not can
it be done using coloured fonts? Thanks for any help.

TIA
Brian