+ Reply to Thread
Results 1 to 3 of 3

Modify font colour of filtered rows for a select column

  1. #1
    Registered User
    Join Date
    05-05-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2013
    Posts
    2

    Modify font colour of filtered rows for a select column

    Hello guru's

    I need some assistance please to modify this existing macro. It currently changes the rows to yellow for selected filtered rows. In addition, I need it to also change the font colour to red for column F, only for the filtered rows. I execute this macro after i have applied a filter.
    Help much appreciated!



    Sub SelectVisibleNonEmptyRows()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Worksheets("Sheet1") 'Enter your worksheet name here

    Dim lastRow As Long
    lastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row

    ws.Range(ws.Rows(2), ws.Rows(lastRow)).SpecialCells(xlCellTypeVisible).EntireRow.Select

    Selection.SpecialCells(xlCellTypeVisible).Interior.Color = vbYellow
    End Sub

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Modify font colour of filtered rows for a select column

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    05-05-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Modify font colour of filtered rows for a select column

    Dear Sixthsense - thanks so much for the quick reply!! Works great.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Delete rows based on multiple criteria including COLOUR, or while FILTERED
    By Rabbitoh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2020, 12:24 AM
  2. Change font colour of Specific Text within specified column
    By mowens74 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2018, 07:39 AM
  3. [SOLVED] Count how many red colour font text or numeric in a column
    By PRADEEPB270 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-12-2013, 02:56 AM
  4. [SOLVED] Modify this code to select different column
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-17-2012, 11:52 AM
  5. Replies: 4
    Last Post: 08-16-2012, 06:20 PM
  6. Replies: 6
    Last Post: 03-22-2012, 06:29 AM
  7. Replies: 3
    Last Post: 12-18-2011, 12:23 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1