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....


--
dezzymei
------------------------------------------------------------------------
dezzymei's Profile: http://www.excelforum.com/member.php...o&userid=25052
View this thread: http://www.excelforum.com/showthread...hreadid=385747