Colour formatting with VBA
 

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

Colour formatting with VBA
 

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

Colour formatting with VBA
 

Sounds promising. Shall investigate it. Many thanks Max.

Brian

"Max" wrote in message
...
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

Colour formatting with VBA
 

Pleasure`, Brian. Thanks for calling back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"brian" wrote:
Sounds promising. Shall investigate it. Many thanks Max.
Brian