Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Juana Fisher   on Aug 27 In MS Office Category.

Filtering rows by colors


  
Question Answered By: Niran Jainukul   on Aug 27

you cant to filter  by color  , excel not support in this.

you must create private function then use it for fillter

b2 = bcolor(a2) etc....

Function bColor(r As Range) As Integer
bColor = r.Interior.ColorIndex
End Function

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Filtering rows by colors Or get search suggestion and latest updates.


Tagged: