Is there any way to highlight the first two rows automatically after applying filters in a worksheet?
Results 1 to 2 of 2

Thread: Is there any way to highlight the first two rows automatically after applying filters in a worksheet?

  1. #1
    New Member
    Join Date
    Sep 2018
    Posts
    22
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Is there any way to highlight the first two rows automatically after applying filters in a worksheet?

    is there any way that I can coloured the first two rows in a worksheet automatically after applying the filters?This is the overall problem :I have got a sheet with columns like thisitem price criteria1 criteria2I have to frequently filter and note down the price of the first two rows of the item is criteria1 is satisfied ie. it has Yes in front of it and criteria2 is not satisified i.e. it has no in front of it. Similarly, I have to note down the price of the first row of the item when criteria 2 is satisfied that is, it has Yes in front of it and criteria. One is not satisfied that is, it has in front of it.I sometimes end up taking the price of the second and third row instead of the first row. It has to do with my vision disability and I was thinking that if I can highlight the first two rows, then hopefully I won't make mistakes.in summary, we just want the first two rows to be highlighted . Even if the increase keep on changing after applying different filters.Thank you for any inputs

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,051
    Post Thanks / Like
    Mentioned
    461 Post(s)
    Tagged
    46 Thread(s)

    Default Re: Is there any way to highlight the first two rows automatically after applying filters in a worksheet?

    Open the name manager > New > Enter a name (I've called it visible) > in the refers to box enter =GET.CELL(17,INDIRECT("rc",FALSE)) > OK > Close
    Then in an unused column on your sheet starting with the first row of data enter =Visible (change to the name you have used) & fill down.
    Select your data (excluding any headers) and In conditional formatting enter this formula
    =COUNTIF($AF$2:$AF2,">0")<=2
    (change column & start row to suit)
    Select format colour & give it a go

    PS the workbook will need to be saved as a macro enabled workbook
    Last edited by Fluff; Jun 7th, 2019 at 02:45 PM.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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