Conditional Formart

[Closed]
Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

i have like four colums like below

Name Age DOB Status
AAA 23 XXXX Active
BBB 25 xxxx Released
CCC 18 XXXX Active

When staus colum is released status entire row (text)need to red.
how i can apply condition for this in excel.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
try this macro

Sub test()
Dim r As Range
Set r = Range("A1").CurrentRegion
r.Cells.Interior.ColorIndex = xlNone
r.AutoFilter field:=4, Criteria1:="Released"
r.Offset(1, 0).Resize(r.Rows.Count - 1).SpecialCells(xlCellTypeVisible).Interior.ColorIndex = 3
ActiveSheet.AutoFilterMode = False
End Sub

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!