M
MarkHear1
Hi All,
I have set up conditional formatting so that alternate rows on my
worksheet are shaded, that alone works fine.
However, I now wish to make it so that the row containing the active
cell is shaded to a different color.
I attempted this with VBA however, because of the conditional
formatting, the shading was only visible on the cells not influenced
by the conditional formatting.
Can any body offer any ideas as to how I can get around this?
Many Thanks,
Mark
I have set up conditional formatting so that alternate rows on my
worksheet are shaded, that alone works fine.
However, I now wish to make it so that the row containing the active
cell is shaded to a different color.
I attempted this with VBA however, because of the conditional
formatting, the shading was only visible on the cells not influenced
by the conditional formatting.
Can any body offer any ideas as to how I can get around this?
Many Thanks,
Mark