Re: Reset conditional color VB



Daniel

maybe:

Selection.Interior.ColorIndex = xlNone

For example:

With Selection.Interior
.ColorIndex = 6 ' set the colour to yellow
.Pattern = xlSolid
End With
Selection.Interior.ColorIndex = xlNone ' reset the colour

Or, if you want to change a specific cell:

Range("A1").Interior.ColorIndex = xlNone

Regards

Trevor


"Daniel" <Daniel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:55C2DBB9-D051-49B8-930B-CA07C9EA758B@xxxxxxxxxxxxxxxx
Hi
I used VBA to conditional color bar chart but when I run macro again it
paint on top of last coloring task.
How can I reset the function

Interior.ColorIndex= ....

to begin color my bar chart in fresh condition?
Thanks
Daniel





.