Filtering Issue

Antonw

New Member
Joined
Feb 17, 2010
Messages
42
Hi All,

May be my problem is small, but I could not find a solution for that.

When I do filtering and try to apply (fill color) a color to filtered column it is not possible.

Eg:

01. Data are only in coumn A from A1 to A10.
02. I filter using some criterea and it filters 5 records.
03. I highlight the filtered data.
04. I click on the yellow color to fill color and it takes no color

Anyone has an idea the reason for this and the way I shoud do it?

I can select one by one cells using (Ctrl key) and color them, but when there are lots of data it is not possible.

Thanks
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

vinodxls

New Member
Joined
Aug 7, 2010
Messages
4
Post the sheet for which you facing prob, so that others have a clear idea!!
 

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
What version of XL are you using? Are there any protections on the sheet?
 

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196

ADVERTISEMENT

I've tried this a few times and no problems. Are you sure there are no protections on the sheet? How are you performing the selection?
 

Antonw

New Member
Joined
Feb 17, 2010
Messages
42
Hi Weaver & VinodXLS,

Just let me know how I can attach a file here. I will attach it for your referance
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,113
Messages
5,857,454
Members
431,880
Latest member
kar2rost

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top