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

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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,811
Messages
5,574,449
Members
412,595
Latest member
slim313
Top