Formatting Selection of cells.

J

jimbob007

My database contains rows of information which can be subdivided into 3
types <1,2 and 3>. I set up a filter but would like it to automatically
format the rows of categories 1 and 2 leaving 3 untouched. For instance
change colour of rows for cat 1 and change text font for rows for cat 2
when I enter these numbers in the relevant cells.

IS THIS POSSIBLE?
 
B

Bob Phillips

Conditional formatting - menu Format>Conditional Formatting

Add a condition for values equal to cat 1 and another for cat 2. You can set
the set the font attributes and the pattern attributes.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
S

Stefi

Yes, you can do that with a Change event procedure something like this one:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then 'Column A marking your categories
Select Case Target.Value
Case 1
Rows(Target.Row).Interior.ColorIndex = 6
Case 2
Rows(Target.Row).Font.Name = "Times"
End Select
End If
End Sub

Regards,
Stefi

„jimbob007†ezt írta:
 
J

jimbob007

Thank you for each of your time. I appreciate all your help.

Kind Regards,
jimbob00
 
Top