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
Related:
- Conditional Formart
- Excel conditional formatting if another cell contains specific text - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Conditional hyperlink excel ✓ - Excel Forum
- Conditional formatting 3 color scale percentages ✓ - 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