Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Conditional Formatting - xlDyanmic Add-IN
I want to apply conditional formatting on approximately 20 conditions. I
downloaded the xlDynamic Add-IN, which is exactly what i want to do, but it doesn't seem to work with megred cells. When I apply conditional formats to merged cells, it un-merges them and re-merging them doesn't work either. I want to apply this to multiple ranges within a worksheet (to a total of about 3000 merged cells within a worksheet). I'm not very familiar with worksheet code and from what I've read in other postings, that looks a little complicated for multiple ranges with this many conditions. I basically just want to change the fill color of the cell based on an input number of 1 through 20. I am running Excel 2003 and XP Pro. Thanks |
#2
|
|||
|
|||
You have found another reason to avoid merged cells. "Center across columns"
will give you the same effect in most cases without the baggage. I have removed merged cells from any file I use. "Mike M" wrote: I want to apply conditional formatting on approximately 20 conditions. I downloaded the xlDynamic Add-IN, which is exactly what i want to do, but it doesn't seem to work with megred cells. When I apply conditional formats to merged cells, it un-merges them and re-merging them doesn't work either. I want to apply this to multiple ranges within a worksheet (to a total of about 3000 merged cells within a worksheet). I'm not very familiar with worksheet code and from what I've read in other postings, that looks a little complicated for multiple ranges with this many conditions. I basically just want to change the fill color of the cell based on an input number of 1 through 20. I am running Excel 2003 and XP Pro. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |