Conditional Formart

Closed
dhavala - Apr 9, 2015 at 02:01 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 9, 2015 at 02:39 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Apr 9, 2015 at 02:39 AM
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
0