Help! Data Validation/Filters......

G

genuinegal

New Member
Joined
Oct 10, 2005
Messages
38
:biggrin: Hi all,

Ok, rather than me filtering text, or certain amounts, can i filter 'COLOUR SHADED CELLS'?

Thanks!

GG
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
G

genuinegal

New Member
Joined
Oct 10, 2005
Messages
38
Hi, i know, ive just found out that i can't do it unless i use the VBfeature...

I carried out a search on this board and found this link, it told me to copy and paste into a new window in VB...:

http://www.cpearson.com/excel/SortByColor.htm

Now, im not an expert when it comes to VB, but i managed to open a new window in VB (i am 'familiar with VB' but really need help..)/

Im stuck at at the bit where the paragraph starts:

'Of course, change the reference A1 to the first cell in the range. Use Edit, Fill, Down to fill this formula down to the entire range of data you want to sort....'

It says in these cells i'll see numbers 1-56, but i can't....

Anyone help me please!?

Thanks!

GG
 
You must log in or register to reply here.

Similar threads

R
  • Solved
Excel VBA - color/shade alternating rows in filtered list
Replies
8
Views
105
robertvdb
R
C
  • Question
Drop Down Menu to Filter Data
2
Replies
12
Views
297
Fluff
Fluff
T
  • Solved
Help with FILTER function
Replies
3
Views
50
Fluff
Fluff
J
  • Solved
Filter Table Based on Cell Value Without Exact Match- VBA
Replies
3
Views
215
jewkes6000
J
R
  • Solved
VBA Worksheet Change Event Multi Filter
Replies
9
Views
161
Fluff
Fluff

Watch MrExcel Video

Learn Excel - Text Instead of Numbers in Pivot Table - Podcast 2223

Forum statistics

Threads
1,123,242
Messages
5,600,506
Members
414,385
Latest member
Lioness227

Share this page

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