Filter more than 2 color cells

[neeraj2050]

Greetings!!

Into a column, there are data into which different color is applied. I have to filter two colors at a time. Would that be possible? Please suggest any Non VBA solution

Regards
Neeraj Kumar Agarwal

 

[Chihiro]

Not possible without VBA, or using logic other than coloring.

 

[bosco_yip]

Non VBA solution, try to use helper column and Get.cell function

1] Select B3 >> Define Name >>

>> Name: CellHasColor

>> Refers To:

=(GET.CELL(63,Sheet1!$A3)+NOW()*0)>0

2] In helper column B3, copied down :

=CellHasColor

3] Filter color using helper column to select "TRUE"

p.s. Since Get.cell () is a Macro 4 function, file must saved in xlsm type.

Regards
Bosco

 

[Chihiro]

I've used that in the past, but I keep forgetting about it, since I hardly ever use it. Thanks for a reminder