+ Reply to Thread
Results 1 to 5 of 5

Column header to fill with a colour when filter applied?

Hybrid View

  1. 04-03-2017, 09:03 AM #1
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Column header to fill with a colour when filter applied?

    If you know the RGB values you can use them like this
    Range("S1,V1,W1").Interior.Color = RGB(25, 25, 25)
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  2. 04-03-2017, 09:11 AM #2
    JRC1
    JRC1 is offline
    Forum Contributor
    Join Date
    02-20-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    133

    Re: Column header to fill with a colour when filter applied?

    Great stuff useful to know, thanks for your help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Very Strange Occurence when copy/paste row of data with hidden column and filter applied!
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2014, 02:02 PM
  2. VBA to find first row under header, after filter has been applied.
    By Chris Acheson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2014, 11:50 AM
  3. Change cell colour when applied filter is on
    By DanielPodo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2012, 09:30 AM
  4. [SOLVED] Need Macro to Select All Files in a Column After Filter Applied
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-12-2012, 05:33 PM
  5. Copy filtered data & paste into adjecent column with filter applied in Excel 2007
    By hifliers in forum Excel General
    Replies: 5
    Last Post: 05-23-2012, 10:33 AM
  6. Colour empty cells if under Column Header x
    By Jessica.Bush in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-12-2010, 08:36 AM
  7. Filter columns by fill colour
    By Ascesis in forum Excel General
    Replies: 3
    Last Post: 08-06-2006, 05:50 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1