Conditional Formatting - xlDyanmic Add-IN

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top