why dont u use conditional formatting?

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


dezzymei wrote :


Ok, so I have just really started off in my programming crusade...I
know a lot of basic html and am now looking at vba after using basic
excel for many uses - managing personal fund to working out odds of
stocks...etc...so I know quite a bit about excel but I want to expand
my knowledge...

Anyway, what I want to do is select column "I" say and search in that
column for every value = "Positive". I then change the font and colour
and edit all cells in that column which are = "Positive". This
therefore allows me to see all of the stocks which has gone
positive...

what I have so far is

Private Sub CommandButton1_Click()

Range("I:I").Select

*********

With Selection.font
.Name = "Arial Black"
.FontStyle = "Bold"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleSingle
.ColorIndex = xlAutomatic
End With
Selection.font.ColorIndex = 4

With Selection.Interior
.ColorIndex = 2
.Pattern = xlSolid


End With



End Sub

I am now stuck on the starred part...I want to look up all cells which
have value = "Positive" in that selection and then apply the
formatting.

I'm sure its something easy like =match(Positive,I:I) then do the
formatting stuff....