Conditional Formatting

[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

 

[Guest]

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

 

[Gord Dibben]

This code does not override the CF on the alternate rows.

Chip Pearson's Rowliner add-in should do the trick.

http://www.cpearson.com/excel/RowLiner.htm


Gord Dibben MS Excel MVP