Hi all,I have used mergedcells property to merge cells with same text in specific column, I want to know if is possible to make same color for all rows in the the range with "mergedrows" (see attachment, the color of rows are different, I want to make it same )
thank you very much Mike, InitializeRow event was the solution, thank you :)
can you give me one example Mike?
Hi,
Where are these row colors coming from?
There's no built-in support for applying an appearance to all of the merged rows. In fact, this is not possible, because the merged cells in different columns could "overlap".
But you could handle the InitializeRow event and color the row based on the value of the merged cell very easily.