Hi,
I have a excel sheet containing rows highlighted with many colors. Is there any way to filter these rows? i,e I need to filter only a sigle colored row (green coloured rows) in the sample spreadsheet need to be filtered and count the total rows contain in that colour.
Your help will be highly appreciated.
with Thanx
Kutty
Good afternoon assainar kutty
Excel doesn't have a native built in way to filter via colour. However, Ron de Bruin has made available a free add-in that plugs a few holes in Excel's filter functionality. You can download it for free from here.Originally Posted by assainar kutty
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Hi Dominic
Thanx for your prompt response.
Rgds,
Kutty
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks