Not directly - you'd need either a macro to do it, or a helper column with a suitable UDF to give you the colorindex value of the target cell(s) so that you could then use a regulkar autofilter.
Enter this code into a blank module within your project (Alt+F11, Insert > Module) :
Code:
Function CellColour(UsrRng As Range) As Integer
Application.Volatile True
CellColour = UsrRng(1, 1).Interior.ColorIndex
End Function
Lets say the range you want to filter is A1:E100, and the coloured cells are in column A. In cell F1 put the formula : =CellColour(A1) and copy it down.
This will return the ColorIndex value of each cell in column A. You can now record your macro, but filter by column F (not A), but the end result will have the same efect as if you'd filtered by colour in column A.
Next time you post remember to be more explicit about what you want - you'll get an answer quicker, and better tailored to what you want.
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.