Conditional Formatting

  • Thread starter Thread starter MarkHear1
  • Start date Start date
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
 
Try this, i learned from a website a while back... let me know if it still
works...

Static PreRange As Range
On Error Resume Next
Target.EntireRow.Interior.ColorIndex = 10
PreRange.EntireRow.Interior.ColorIndex = xlColorIndexNone
Set PreRange = Target

End Sub
 
Back
Top