| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, colour formatting (text and background) reverts to blk | Excel Discussion (Misc queries) | |||
| Can you apply split colour formatting to the same cell? | Excel Discussion (Misc queries) | |||
| Conditional formatting: Colour coding | Excel Discussion (Misc queries) | |||
| How Can I Read Formatting Data (ie Background Colour) | Excel Discussion (Misc queries) | |||
| colour due to conditional formatting & hyperlink/shortcut to a directory | Excel Worksheet Functions | |||
Linear Mode
