Forum Discussion

pcorbitt's avatar
pcorbitt
Copper Contributor
Jul 17, 2023

Conditional Formatting the results of a Filter formula

I had this functioning, but it got deleted and for the life of me I cannot figure out how to replicate it! I have an Excel Worksheet CURRENT PROJECTS. In it I have two tabs "data" and "results".  O...
Excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 18, 2023

    pcorbitt 

    Thanks. You'll have to include the Project Type column in the filter.

    And the conditional formatting formula should refer to the column on the RESULTS sheet.

     

    You can hide column E on the RESULTS sheet if you wish.

    See the attached version.

pcorbitt's avatar
pcorbitt
Copper Contributor
Great, Hans. Thank you. That works well for the static array, but if I change more of my data to ACTIVE status, and thereby extend the array, the formatting does not automatically apply. Is it possible to fix that?
HansVogelaar's avatar
HansVogelaar
MVP
Jul 18, 2023

pcorbitt 

Did you select a large enough range to accommodate more results?

  • pcorbitt's avatar
    pcorbitt
    Copper Contributor
    Jul 18, 2023

    HansVogelaar - I did. I had applied the CF to just 4 cells, and it came out just right...like this:

     

    then when tried to change another company on my list to ACTIVE and it came out like this:

     so I tried to add the CF to more cells below and got this...

    Could my FILTER be wrong?  

    =FILTER('Projects 2023'!A3:B310,'Projects 2023'!A3:A310="ACTIVE")

     

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jul 18, 2023

      pcorbitt 

      Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources