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

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

Hi Mike,
If the cells are constants (no formulas), how about using a
Change Event macro instead.
http://www.mvps.org/dmcritchie/excel/event.htm#case
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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