Conditional Formart
Closed
dhavala
-
Apr 9, 2015 at 02:01 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 9, 2015 at 02:39 AM
venkat1926 Posts 1863 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.
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.
Related:
- Conditional Formart
- Excel conditional formatting based on date - Guide
- Openoffice conditional formatting - Guide
- Nested conditional statements in excel - Guide
- Conditional formatting based on date ✓ - Excel Forum
- Copy conditional formatting to other cells ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 9, 2015 at 02:39 AM
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
