Forum Discussion

pcorbitt's avatar
pcorbitt
Copper Contributor
Jul 17, 2023
Solved

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.

HansVogelaar's avatar
HansVogelaar
MVP
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.

Resources