Filter based on color

Erika Cilengir

Is there a way to filter a sheet based on the color of a cell in a particular column?  So, for example, I set up conditional formatting such that when an item is overdue, a particular cell turns red.  I would then like to filter the sheet such that only the items with that cell as red are shown.

Brett Evans

You could add a simple step to make it possible.  

 

Use your conditional formatting logic to assign a value to a cell in a hidden column. 

Then you can filter on the result in that hidden column.

 

Good luck,

Brett

 

Erika Cilengir

I don't see a way to do that.  Please advise.  Thanks!!

Brett Evans

Create a new column, call it desiredcolor.

Add logic to new column such as IF( %complete < 1, IF( [Assigned To]6 = "Erika", "Red", "Green"), "Green")

 

In your conditional formatting create a rule - "If desiredcolor is Red apply this Formatiing to entire row."  And set the format for the row; red, bold, strikethru, etc. to be whatever you want.

 

 

 

Bob Andrews

Filter your sheet by the same paremeter that you use to set the conditional formatting rule. For example "if due date is in the past and % complete is < 1" (would be two filters).

Erika Cilengir

Appreciate your feedback, Brett and Bob!  I will try out your ideas.