Hi - trying to hammer out a macro (see below). If any values in Column C
contain any one of the following values: "Consent Order" or "Review" or
varying characters containing the word "Closed"....thought a wildcard
around Closed would take care of that, then I want the font color for
all the values in that particular row(s) to turn red.

Below is what I've hammered out (don't laugh :) )......it's not
working so sure would appreciate some help. THANK YOU.

Dim myrange
myrange = ActiveSheet.Columns("c").Value
If myrange = ["review", "consent order", "*closed*"] Then
ActiveSheet.Rows.Select
Selection.Font.Color = vbRed
End If
End Sub


--
ddd
------------------------------------------------------------------------
ddd's Profile: http://www.excelforum.com/member.php...o&userid=31068
View this thread: http://www.excelforum.com/showthread...hreadid=507521